or
| Private Sub GridView_RowsChanged(ByVal sender As System.Object, ByVal e As Telerik.WinControls.UI.GridViewCollectionChangedEventArgs) Handles GridView.RowsChanged |
| Dim objconnection1 As New SqlClient.SqlConnection("Data Source=(local);Initial Catalog=OTMC_HR; Integrated Security=True") |
| Dim objDataAdapter1 As New SqlClient.SqlDataAdapter("Use OTMC_HR SELECT E.EmployeeID, FirstName, lastname, " & _ |
| "E.WorkingPhone, HomePhone, E.Email, P.PositionTitle,D.DepartmentName " & _ |
| "FROM Employee AS E INNER JOIN Department AS D ON E.DepartmentID = D.DepartmentID " & _ |
| "INNER JOIN Position AS P ON E.PositionID = P.PositionID ", objconnection1) |
| Dim objDataSet1 As DataSet |
| objDataSet1 = New DataSet() |
| objDataAdapter1.Fill(objDataSet1, "EmployeeContactList") |
| If (e.Action = Telerik.WinControls.Data.NotifyCollectionChangedAction.ItemChanged) Then |
| objDataAdapter1.Update(objDataSet1) |
| End If |
| End Sub |