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();

Comments

Popular posts from this blog

show (value1,value2) in one column in sql