or


<telerik:GridBoundColumn DataField="Whs" FilterControlAltText="Filter Whs column" HeaderText="Whs" SortExpression="Whs" UniqueName="Whs"> </telerik:GridBoundColumn> <telerik:GridAutoCompleteColumn DataTextField="ItemNo" DataValueField="ItemNo" DataField="ItemNo" DataSourceID="sqlDS_mitmas" Filter="StartsWith" InputType="Text" HeaderText="ItemNo" UniqueName="ItemNo"> </telerik:GridAutoCompleteColumn>Protected Sub RadGrid1_ItemDeleted(sender As Object, e As Telerik.Web.UI.GridDeletedEventArgs) Handles RadGrid1.ItemDeleted Dim dataItem As GridDataItem = CType(e.Item, GridDataItem) Dim whs As String = dataItem("Whs").Text Dim itemno As String = dataItem("ItemNo").Text Dim itemname As String = dataItem("ItemName").Text Dim deletedby = User.Identity.Name.ToString() InsertHistory(whs, itemno, itemname, deletedby) End Sub
DataTable assets = new DataTable(); using (SqlConnection connection = new SqlConnection(ConnectionString)) { using (SqlCommand command = new SqlCommand("GetAssetHierarchyByUserId", connection)) { command.Parameters.Add(new SqlParameter("UserId", UserId)); command.CommandType = CommandType.StoredProcedure; SqlDataAdapter adapter = new SqlDataAdapter(command); connection.Open(); try { adapter.Fill(assets); } finally { connection.Close(); } }