Hello I am Populating a datagrid by binding a DataView to the the Datagrid. The Dataview is built from Storedprocedure Query.
Can anyone tell me how can I propogate the changes in the datagrid back to the database. I am assuming the user may of chaged values in multiple rows of the datagrid.
Below is a snippet of code that binds the SP results to the datagrid.
Dim oShowcode As Object
Dim oShowyear As Object
Dim oStartdate As Object
Dim oEnddate As Object
Dim oerror As Object
Dim oBatch As Object
Dim mydatatable As New DataTable
mydatatable = myConnection.ArSPExecReturnDataTable("PrsgDocumentrequestbatchAdmin", oShowcode, oShowyear)
Dim mydataset As New DataSet
Dim mydataview As DataView = New DataView(mydatatable)
mydataset = mydatatable.DataSet
mydataset.Tables(0).TableName = "results"
MyDataGrid.DataSource = mydataview