protected void Page_Load(object sender, EventArgs e) { RadAutoCompleteBox1.DataSource = GetData(); RadAutoCompleteBox1.DataTextField = "Type"; RadAutoCompleteBox1.DataValueField = "Type";
} private static DataTable GetData() { DataTable dt = new DataTable(); //Set the datafield name DataColumn cl = new DataColumn("status"); dt.Columns.Add(cl); cl = new DataColumn("Item_Code"); dt.Columns.Add(cl); cl = new DataColumn("Item_Desc"); dt.Columns.Add(cl); cl = new DataColumn("Vendor_Name"); dt.Columns.Add(cl); cl = new DataColumn("Uom"); dt.Columns.Add(cl); cl = new DataColumn("Moq"); dt.Columns.Add(cl); cl = new DataColumn("Qty"); dt.Columns.Add(cl); cl = new DataColumn("Cur"); dt.Columns.Add(cl); cl = new DataColumn("Price"); dt.Columns.Add(cl); cl = new DataColumn("Total"); dt.Columns.Add(cl); cl = new DataColumn("Type"); dt.Columns.Add(cl); //Set the static data for row 1 DataRow dr = dt.NewRow(); dr[0] = ""; dr[1] = "07-11-017"; dr[2] = "PAPER PUNCHER (3 HOLES)"; dr[3] = "Internal"; dr[4] = "PC"; dr[5] = "1"; dr[6] = "1"; dr[7] = "SGD"; dr[8] = "130.00"; dr[9] = "130.00"; dr[10] = "NS"; dt.Rows.Add(dr); //Set the static data for row 2 dr = dt.NewRow(); dr[0] = ""; dr[1] = "07-09-069"; dr[2] = "BINDING STRIPS A4 (MULTI-COLOUR) (LOT OF 100/50PC) "; dr[3] = "Internal"; dr[4] = "PC"; dr[5] = "1"; dr[6] = "1"; dr[7] = "SGD"; dr[8] = "60.00"; dr[9] = "60.00"; dr[10] = "NS"; dt.Rows.Add(dr); //Set the static data for row 3 dr = dt.NewRow(); dr[0] = ""; dr[1] = "01-38-002"; dr[2] = "LAMINATING MACHINE A4, LMA400"; dr[3] = "Internal"; dr[4] = "PC"; dr[5] = "1"; dr[6] = "1"; dr[7] = "SGD"; dr[8] = "160.00"; dr[9] = "160.00"; dr[10] = "NS"; dt.Rows.Add(dr); //Set the static data for row 4 dr = dt.NewRow(); dr[0] = ""; dr[1] = "99-09-901"; dr[2] = "BOLTED CONNECTOR"; dr[3] = "Internal"; dr[4] = "PC"; dr[5] = "10"; dr[6] = "10"; dr[7] = "SGD"; dr[8] = "1.50"; dr[9] = "15.00"; dr[10] = "ST"; dt.Rows.Add(dr); //Set the static data for row 5 dr = dt.NewRow(); dr[0] = ""; dr[1] = "99-07-905"; dr[2] = "GUY STRAIN INSULATOR"; dr[3] = "Internal"; dr[4] = "PC"; dr[5] = "100"; dr[6] = "100"; dr[7] = "SGD"; dr[8] = "1.00"; dr[9] = "100.00"; dr[10] = "ST"; dt.Rows.Add(dr); //Set the static data for row 6 dr = dt.NewRow(); dr[0] = ""; dr[1] = "99-01-505"; dr[2] = "HOT LINE CLAMP"; dr[3] = "Internal"; dr[4] = "PC"; dr[5] = "500"; dr[6] = "500"; dr[7] = "SGD"; dr[8] = "2.00"; dr[9] = "1000.00"; dr[10] = "ST"; dt.Rows.Add(dr); return dt; }
<telerik:RadGrid ID="RadGrid1" AllowFilteringByColumn="true" PageSize="20" ShowFooter="True" AllowPaging="True" AllowSorting="true" AutoGenerateColumns="false" GridLines="None" ShowStatusBar="true" runat="server" OnItemCreated="RadGrid1_ItemCreated" onneeddatasource="RadGrid1_NeedDataSource"> <GroupingSettings CaseSensitive="false" /> <MasterTableView EditMode="InPlace" AllowFilteringByColumn="True" ShowFooter="True" DataKeyNames="ArticleID" TableLayout="Fixed"> <Columns> <telerik:GridBoundColumn DataField="Title" HeaderText="Tiêu đề"> </telerik:GridBoundColumn> <telerik:GridDateTimeColumn FilterControlWidth="95px" DataField="AddedDate" HeaderText="Ngày đăng" SortExpression="AddedDate" UniqueName="AddedDate" PickerType="DatePicker" EnableRangeFiltering="true" DataFormatString="{0:dd/MM/yyyy}"> <HeaderStyle Width="160px" /> </telerik:GridDateTimeColumn> <telerik:GridTemplateColumn DataField="CateID" HeaderText="Danh mục" UniqueName="CateID" HeaderStyle-Width="200px" SortExpression="DisplayOrder"> <FilterTemplate> <telerik:RadComboBox ID="RadComboBoxCategories" runat="server"> </telerik:RadComboBox> </FilterTemplate> <ItemTemplate> <%# Eval("udv_Categories.Title") %> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> </MasterTableView> </telerik:RadGrid>$find("<%= MainRibbonBar.ClientID %>").findButtonByValue(button).get_owner().set_text("newtext");<span class="rrbButtonMid rrbSplitButton"><span class="rrbButtonIn"><span class="rrbImagePlaceholder"><img alt="Item Image" src="/Images/Icons/Save.png" class="rrbButtonImage" style="visibility: visible;"></span><span class="rrbButtonText"><span class="rrbTextContent">newtext</span></span><span class="rrbButtonArrow"><span class="rrbIcon"></span><span class="rrbButtonText"><span class="rrbTextContent">oldtext</span></span></span></span></span>
Protected Sub RadGrid1_UpdateCommand(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles RadGrid1.UpdateCommand
'If e.CommandName = RadGrid.UpdateCommandName Then
If e.CommandName = "UpdateEdited" Then
If TypeOf e.Item Is GridDataItem Then
Dim editItem As GridDataItem = CType(e.Item, GridDataItem)
Dim id As String = editItem.GetDataKeyValue("FIRM_CODE").ToString()
If id IsNot Nothing Then
//I am stuck here. How do I fetch the values for COMET_DESCRIPTOR and COMET_TRANS_NOTES
Dim UpdateCommand As String = "update tablename set COMET_DESCRIPTOR = '@COMET_DESCRIPTOR', COMET_TRANS_NOTES ='@COMET_TRANS_NOTES' where FIRM_CODE = '" & id & "' and REF_YY||REF_MM ='@REF_YY'||'@REF_MM'"
End If
End If
End If
End Sub
