Private Sub SaveData
Dim txtFormFieldValue, txtStudentFormDetailsDBID, txtFormFieldTagName As TextBox
Dim strFormFieldValue, strStudentFormDetailsDBID, strFormFieldTagName As String
Dim grdItem As DataGridItem
For Each grdItem In Me.DataGrid1.Items
'-- not sure if this IF is really necessary. I haven't tested it without it.
If grdItem.ItemType = ListItemType.Item Or grdItem.ItemType = ListItemType.AlternatingItem Then
txtStudentFormDetailsDBID = grdItem.Cells(0).FindControl("txtStudentFormDetails_DBID")
strStudentFormDetailsDBID = txtStudentFormDetailsDBID.Text
txtFormFieldValue = grdItem.Cells(0).FindControl("txtFormFieldValue")
strFormFieldValue = txtFormFieldValue.Text
txtFormFieldTagName = grdItem.Cells(0).FindControl("txtFormFieldTagName")
strFormFieldTagName = txtFormFieldTagName.Text
'-- method that updates the SQL server data for that row
SpEdObj.UpdateStudentFormDetails(strStudentFormDetailsDBID, StudentFormDBID, strFormFieldTagName, strFormFieldValue, Session("UserID"))
End If
Next
End Sub
Private Sub DataGrid1_UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.UpdateCommand
Dim SpEdObj As New StudentFormsClass(Session("cn"))
Dim txtFormFieldValue, txtStudentFormDetailsDBID, txtFormFieldTagName As TextBox
Dim strFormFieldValue, strStudentFormDetailsDBID, strFormFieldTagName As String
txtStudentFormDetailsDBID = e.Item.FindControl("updStudentFormDetailsDBID")
strStudentFormDetailsDBID = txtStudentFormDetailsDBID.Text
txtFormFieldValue = e.Item.FindControl("updFormFieldValue")
strFormFieldValue = txtFormFieldValue.Text
txtFormFieldTagName = e.Item.FindControl("updFormFieldTagName")
strFormFieldTagName = txtFormFieldTagName.Text
'-- StudentFormDBID is a property on the form
SpEdObj.UpdateStudentFormDetails(strStudentFormDetailsDBID, StudentFormDBID, strFormFieldTagName, strFormFieldValue, Session("UserID"))
'SpEdObj.SaveStudentFormDetail(myFormDetailDS)
'-- go get the updated information
myFormDetailDS = SpEdObj.getStudentFormDetailNoDem(StudentFormDBID)
' repopulate the data grid to reflect the changed row
DataGrid1.EditItemIndex = -1
Me.BindGrid()
End Sub