By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,215 Members | 1,936 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,215 IT Pros & Developers. It's quick & easy.

Updating Data from a dataGrid

P: n/a
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
May 12 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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..

May 12 '06 #2

P: n/a
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?

May 12 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.