Updating Data from a dataGrid

12 May 2006 11:04 AM

marcmc

Hey, I have never used a datagrid/dataset/adaptor/table method for updating
data, I have always used direct updates to the database so ADO is quite new
to me.

I have a datagrid and I change a value in one of the fields.
I hit save and the following code runs...

Dim da As SqlClient.SqlDataAdapter = New SqlClient.SqlDataAdapter("Select *
from MISRE_Threshold", cn)
       da.Update(dsThreshold, "MISRE_Threshold")

my code to populate the datagrid is as below, what am i missing to actually
update the data in the database......

Private Sub Thresholds_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load

        UserName.Text = dbProps.MyUserName
        Password.Text = dbProps.MyPassword
        Database.Text = dbProps.MyDatabase
        Server.Text = dbProps.MyServer

        Try
            cn = New SqlClient.SqlConnection("user id=" & UserName.Text &
";password=" & Password.Text & ";database=" & Database.Text & ";server=" &
Server.Text)
            cn.Open()
            cmdSelect.Connection = cn

            Dim da As SqlClient.SqlDataAdapter = New
SqlClient.SqlDataAdapter("Select * from MISRE_Threshold", cn)
            'Dim dsThreshold As DataSet = New DataSet

            ' fill dataset
            da.Fill(dsThreshold, "MISRE_Threshold")

            'Attach DataSet to DataGrid
            dgThreshold.DataSource = dsThreshold.DefaultViewManager
            Dim dt As New DataTable
            dt.CaseSensitive = False
            dt = dsThreshold.Tables("MISRE_Threshold")

        Catch ex As Exception
            MessageBox.Show("Error: Could not establish database connection")
        End Try

    End Sub

12 May 2006 2:15 PM

rj

hi,

i dont know about your code, but if you're using visual studio 2002 or
later, you can use the data form wizard. this will add the buttons to
your form and all you have to do is sort out the layout.
To go there click 'new item' > select dataform wizard and follow the
wizard.
Its a really easy way of doing simple data forms.

hope it helps..

12 May 2006 3:12 PM

marcmc

Thanks but I am trying to write code that will update the dataset (and
database) with any changes the user makes to the datagrid. I tried the
DataAdaptor configuration wizard but it doesn't work.

How do I overcome this issue?