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
>