Click here to Skip to main content
15,885,244 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
please help me...

C#
<pre> DataTable dt = new DataTable();


        dt.Columns.Add("Exp_upto_Premonth", typeof(string));
        dt.Columns.Add("Exp Upto", typeof(string));
        dt.Columns.Add("Exp During", typeof(string));
        dt.Columns.Add("ExpUptoNow", typeof(string));
        dt.Columns.Add("schemeno", typeof(string));
        dt.Columns.Add("sch_amount", typeof(string));
        dt.Columns.Add("Desciption", typeof(string));
        dt.Columns.Add("sdate", typeof(string));
        //dt.Columns.Add("PreMonth", typeof(string));
        //dt.Columns.Add("CurrMonth", typeof(string));
        DataRow dr = dt.NewRow();
         Insrtds = GetDataExpen(wrkno, strtdt, CreatdDate,preMonth, enddt,curmonyr);
               

                if (Insrtds.Tables[0].Rows.Count != 0)
                {
                    for (i = 0; i < Insrtds.Tables[0].Rows.Count; i++)
                    {
                        //dr["schemeno"] = Insrtds.Tables[1].Rows[0][i];
                        dr["Exp_upto_Premonth"] = 
                         Insrtds.Tables[0].Rows[i]"Premonth"];
                        dr["Exp Upto"] = Insrtds.Tables[0].Rows[i]["ExpUpto"];
                        dr["Exp During"] = Insrtds.Tables[0].Rows[i]["CurrMonExp"];
                        dr["ExpUptoNow"] = Insrtds.Tables[0].Rows[i]["ExpUptoNow"];
                        dr["schemeno"] = Insrtds.Tables[0].Rows[i]["Schemeno"];
                        dr["sch_amount"] = Insrtds.Tables[0].Rows[i]["sch_amount"];
                        dr["Desciption"] = Insrtds.Tables[0].Rows[i]["disp"];
                        dr["sdate"] = Insrtds.Tables[0].Rows[i]["Schdate"];
                        dt.AcceptChanges();
                        //object[] row1 = dr.ItemArray;
                        
                    }
                    //InsertData(Insrtds,PreMonthName,CurrMonthName);
                }
                
                
            }
        }
        dt.Rows.Add(dr.ItemArray);
      
        ViewState["dt"] = dt;


What I have tried:

i want to insert multiple records into datatable using loop but i get only 1 record
Posted
Updated 23-May-18 8:38am

1 solution

for (i = 0; i < Insrtds.Tables[0].Rows.Count; i++)
                   {

                       dr = dt.NewRow();//Add this code
                       dr["Exp_upto_Premonth"] =
                        Insrtds.Tables[0].Rows[i]"Premonth"];
                       dr["Exp Upto"] = Insrtds.Tables[0].Rows[i]["ExpUpto"];
                       dr["Exp During"] = Insrtds.Tables[0].Rows[i]["CurrMonExp"];
                       dr["ExpUptoNow"] = Insrtds.Tables[0].Rows[i]["ExpUptoNow"];
                       dr["schemeno"] = Insrtds.Tables[0].Rows[i]["Schemeno"];
                       dr["sch_amount"] = Insrtds.Tables[0].Rows[i]["sch_amount"];
                       dr["Desciption"] = Insrtds.Tables[0].Rows[i]["disp"];
                       dr["sdate"] = Insrtds.Tables[0].Rows[i]["Schdate"];
                       dt.AcceptChanges();
                       //object[] row1 = dr.ItemArray;

                   }
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900