Data usage and Mobile phones

When you choose a mobile phone there are some things to consider that do not immediately jump out at you. One of these is data usage, all but the most basic mobile phones now connect to the internet to perform a variety of tasks that are not always visible to you.
     Mobile phones check apps stores for new versions and some download and install automatically if you have said it is ok to do this in the setup. Auto backup systems backup you data to your google or Apple account. Google and Apple have an image backup service that sends copies of your pictures to your account storage space on the internet.
    Apps like Facebook,twitter and Google Plus+ are constantly contacting their servers for new messages again if switched on in setup.


Another thing to consider is Battery life this can be reduced by switching apps on or off and not collecting you mail during the night, This will also help you data usage.

  In short when you are considering a new phone calculate your data usage before you decide you tariff.

Resize data grid view on form resize

Us this to resize a data grid view (datagridview) when you resize the form

Private Sub Form_name__Resize(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Resize

        Me.DataGridView1.Width = 0.88 * Me.Width
    Me.DataGridView1.Height = 0.75 * Me.Height
    End Sub

Error Creating Data Table

Hi All just thought i would post this as i have just spent a bout an hour trying to work out why it would not work in my current project.

I have a  a function to create a data table and return it.


Public Function SQL2DataTable(ByVal sql As String)
        Dim SqlCon1 As String = "Data Source=sprintsql;Initial Catalog = database ;Integrated Security=SSPI;"
        Dim dt As New DataTable
        Dim da As New SqlClient.SqlDataAdapter(sql, SqlCon1)
        da.Fill(dt)
        da.Dispose()
        Return dt
    End Function

This is called like this

Dim dt As DataTable = SQL2DataTable(sql)

 now in this instance this would not work and came back with the error

    Unable to cast object of type 'System.Data.DataTable' to type 'Excel.DataTable'.

After a lot of frustration i found it was cause by having Imports Excel  declared at the beginning  Hope this saved you some time.