or
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>