I am trying to use a datagrid to pull info off of the sql server then preform updates when users have entered info. Right now my problem is sending the data back. I dont know how to go about doing this as I havent stumbled on a way to tell if the data is different and I am not comfortable with the databinding stuff to blindly try and update. I havent used DG's before so any help would be appreciated!

Option Explicit On
Imports System.Data.SqlClient

Public Class Form1
Inherits System.Windows.Forms.Form
Public ds As New DataSet
Public myCmd As SqlCommand
Public myReader As SqlDataReader
Public jobid(250) As String ' I fill jobid on load through a db query that I left out of the prog as it works

#Region " Windows Form Designer generated code "

Dim CallDataBindToDataGrid As New MethodInvoker(AddressOf Me.DataBindToDataGrid)
Dim MyDataSet As DataSet
Dim MyDataAdapter As SqlDataAdapter
Dim MyConnection As New SqlConnection("Initial Catalog=Gress; Data Source=DB;Integrated Security=SSPI;")

'* This sub is straight out of the code I found. It was supposed to work on a differnt
' * DB, so i dont know if the dataMember bit needs to be changed..
Public Sub DataBindToDataGrid()
DataGrid1.DataSource = MyDataSet
DataGrid1.DataMember = "authors"
MyDataAdapter = Nothing
MyDataSet = Nothing
End Sub

Public Sub QueryDataBase(ByVal i As Integer)
Dim MyQueryString As String = "SELECT * FROM tbl_JobPhase where jobid = " & i
MyDataSet = New DataSet
MyConnection.Open()
Dim cmd As New SqlCommand(MyQueryString, MyConnection)
MyDataAdapter = New SqlDataAdapter(cmd)
MyDataAdapter.Fill(MyDataSet, "authors")
MyConnection.Close()
Me.BeginInvoke(CallDataBindToDataGrid)
End Sub

Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
QueryDataBase(jobid(ComboBox1.SelectedIndex))
End Sub
End Class