DATA TABLE BIND WITH GRIDVIEW
DATA TABLE BIND WITH GRIDVIEW
DataTable TempTable = new DataTable();
TempTable.Columns.Add("Business_Place");
TempTable.Columns.Add("Within_State");
TempTable.Columns.Add("Outside_State");
DataRow dtrow;
dtrow = TempTable.NewRow();
dtrow["Business_Place"] = "Factories";
dtrow["Within_State"] = list[0].FACTORY_IN.ToString();
dtrow["Outside_State"] = list[0].FACTORY_OUT.ToString();
TempTable.Rows.Add(dtrow);
dtrow = TempTable.NewRow();
dtrow["Business_Place"] = "Godowns";
dtrow["Within_State"] = list[0].GODOWN_IN.ToString();
dtrow["Outside_State"] = list[0].GODOWN_OUT.ToString();
TempTable.Rows.Add(dtrow);
dtrow = TempTable.NewRow();
dtrow["Business_Place"] = "Branches";
dtrow["Within_State"] = list[0].BRANCH_IN.ToString();
dtrow["Outside_State"] = list[0].BRANCH_OUT.ToString();
TempTable.Rows.Add(dtrow);
dtrow = TempTable.NewRow();
dtrow["Business_Place"] = "Shops/Retail Outlets";
dtrow["Within_State"] = list[0].SHOP_IN.ToString();
dtrow["Outside_State"] = list[0].SHOP_OUT.ToString();
TempTable.Rows.Add(dtrow);
dtrow = TempTable.NewRow();
dtrow["Business_Place"] = "Others";
dtrow["Within_State"] = list[0].OTHERS_IN.ToString();
dtrow["Outside_State"] = list[0].OTHERS_OUT.ToString();
TempTable.Rows.Add(dtrow);
grdBusinessPlace.DataSource = TempTable;
grdBusinessPlace.DataBind();
DataTable TempTable = new DataTable();
TempTable.Columns.Add("Business_Place");
TempTable.Columns.Add("Within_State");
TempTable.Columns.Add("Outside_State");
DataRow dtrow;
dtrow = TempTable.NewRow();
dtrow["Business_Place"] = "Factories";
dtrow["Within_State"] = list[0].FACTORY_IN.ToString();
dtrow["Outside_State"] = list[0].FACTORY_OUT.ToString();
TempTable.Rows.Add(dtrow);
dtrow = TempTable.NewRow();
dtrow["Business_Place"] = "Godowns";
dtrow["Within_State"] = list[0].GODOWN_IN.ToString();
dtrow["Outside_State"] = list[0].GODOWN_OUT.ToString();
TempTable.Rows.Add(dtrow);
dtrow = TempTable.NewRow();
dtrow["Business_Place"] = "Branches";
dtrow["Within_State"] = list[0].BRANCH_IN.ToString();
dtrow["Outside_State"] = list[0].BRANCH_OUT.ToString();
TempTable.Rows.Add(dtrow);
dtrow = TempTable.NewRow();
dtrow["Business_Place"] = "Shops/Retail Outlets";
dtrow["Within_State"] = list[0].SHOP_IN.ToString();
dtrow["Outside_State"] = list[0].SHOP_OUT.ToString();
TempTable.Rows.Add(dtrow);
dtrow = TempTable.NewRow();
dtrow["Business_Place"] = "Others";
dtrow["Within_State"] = list[0].OTHERS_IN.ToString();
dtrow["Outside_State"] = list[0].OTHERS_OUT.ToString();
TempTable.Rows.Add(dtrow);
grdBusinessPlace.DataSource = TempTable;
grdBusinessPlace.DataBind();
Comments
Post a Comment