ExcelDatatable有4条记录，但循环后有1条记录.如何将所有4条记录绑定到我的newcatgorydatatable [英] ExcelDatatable having 4 record but after looping have 1 record .How to bind all 4 record to my newcatgorydatatable

问题描述

for (int i = 0; i < ExcelDatatable.Rows.Count; i++)
             {
                 for (int j = 0; j < ds.Tables[0].Rows.Count-1; j++)
                 {
                     if (ds.Tables[0].Rows[j][1].ToString() == "nvarchar")
                     {
                         string columnname = ds.Tables[0].Rows[j][0].ToString();
                         string datavalue =Convert.ToString(ExcelDatatable.Rows[i][j].ToString());
                         dr[columnname] = datavalue;
                         datavalue = "";
                         columnname = "";
                     }
                     if (ds.Tables[0].Rows[j][1].ToString() == "int")
                     {
                         string columnname = ds.Tables[0].Rows[j][0].ToString();
                         string datavalue =ExcelDatatable.Rows[i][j].ToString();
                         //dr[columnname] =Convert.ToInt32( datavalue);
                         dr[columnname] = datavalue;
                         datavalue = "";
                         columnname = "";
                     }
                     if (ds.Tables[0].Rows[j][1].ToString() == "numeric")
                     {
                         string columnname = ds.Tables[0].Rows[j][0].ToString();
                         string datavalue = ExcelDatatable.Rows[i][j].ToString();
                         dr[columnname] = datavalue;
                         datavalue = "";
                         columnname = "";
                     }

                 }
                 string conut = i.ToString();
                 newcatgorydatatable.Rows.InsertAt(dr,i);
             }

推荐答案

使用ADO.NET代替for ... next循环.快很多了...

在C#ADO.Net中访问Excel电子表格 [如何使用ADO.NET在带有Visual Basic .NET的Excel工作簿中检索和修改记录 [

Use ADO.NET instead for ... next loop. It''s much, much faster...

Accessing Excel Spreadsheets within C# ADO.Net[^]
How to use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET[^]

这篇关于ExcelDatatable有4条记录，但循环后有1条记录.如何将所有4条记录绑定到我的newcatgorydatatable的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！