DataGridView: Updating DS after changes
Posted on 2006-11-01
Hello. I'm working with Datagridview, loading and binding to a dataset created on the fly.
Public Function CropMasterSelect(ByVal WhereClause As String) As DataSet
.Connection = con
.CommandText = "admCropMasterSEL"
.CommandType = CommandType.StoredProcedure
da.SelectCommand = cmd
Me.DataGridView1.DataSource = db.CropMasterSelect(CreateWhereClause).Tables(0)
Me.DataGridView1.Columns(0).Visible = False
My question is, after changes have been made in DataGridView by the user, how do I update those records back to the database? Can I somehow use the dataset that was created on the fly? Any code examples would be helpful.