我有添加行的方法，我从数据库获取数据，我想将行保存在表中 [英] i have method to add row i get my data from database , i want to save row in my table

问题描述

Datatable dt2=getEmaployeeData();

     foreach (DataRow erow in dt2.Rows)
                    {
                        employeeid = erow["employee_code"].ToString();
                        employeeName = erow["employee_name"].ToString();
                        hodID = erow["HODEmployee_Code"].ToString();
                        hodName = erow["HODEmployee_name"].ToString();
                        EmailEmp = GeTEmailAddress(employeeid);
                        EmailHOD = GeTEmailAddress(hodID);
                        totaldays = totaldays - 1;
                        totaldays = UPDATETotalDays(totaldays);
                        totaldays = totaldays - 1;
     
                        test = dt2.Rows.Count;
                       
 
                                DataRow dr = finleTable.NewRow();
                                dr = FinleTable(employeeid, EmailEmp, hodID, EmailHOD);
                              for(int i=0 ;i <test ;i++)
                              {
                                  DataRow sh*t = finleTable.Rows[i];
                               finleTable.AcceptChanges();
                                finleTable.Rows.Add(dr);
                              
                      }
   private DataRow FinleTable(string empid, string empemail,string hodid, string hodemail)
        {
            DataTable newdatatable = new DataTable();
     
            newdatatable.Columns.Add("EmpID");
            newdatatable.Columns.Add("EmpEmail");
            newdatatable.Columns.Add("HODID");
            newdatatable.Columns.Add("HODEmail");
            DataRow dr = newdatatable.NewRow();
 
           
                dr["EmpID"] = empid;
                dr["EmpEmail"] = empemail;
                dr["HODID"] = hodid;
                dr["HODEmail"] = hodemail;
                newdatatable.Rows.Add(dr);
              
           
            return dr;
        }         

推荐答案

您正在接受更改，然后添加新行.那什么也不会发生.

You are accepting changes before adding the new row. Nothing will happen then.

DataRow sh*t = finleTable.Rows[i];
finleTable.AcceptChanges();
finleTable.Rows.Add(dr);</pre>

试试这个:

Try this:

DataRow sh*t = finleTable.Rows[i];
finleTable.Rows.Add(dr);
finleTable.AcceptChanges();

这篇关于我有添加行的方法，我从数据库获取数据，我想将行保存在表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！