Hi, I am currently doing a mock-up project and therefore, have no establish a database for it. I am using this to currently bind data onto the RadGrid.
However, I couldn't find any way to use the same way to bind this datasource for the <NestedViewSettings> DataSourceID.
protected
void
LoadDataToGrid()
{
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);
RadGrid1.DataSource = dt;
RadGrid1.DataBind();
Session.Add(
"dtCart"
, dt);
}
However, I couldn't find any way to use the same way to bind this datasource for the <NestedViewSettings> DataSourceID.