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