如何将数据从一个数据表划分到两个单独的数据表? [英] How to divide the data from one Datatable to two separate Datatable?

问题描述

我正在将数据表导出到Excel工作簿.问题是excel可以限制每张工作表中的行.

所以..

如何将一个数据表划分为两个数据表.

然后我可以在sheet1中有Datatable1，在sheet2中有Datatable2

有任何想法吗?.

I´m exporting Datatable to Excel workbook. Problem is that excel can limited rows in every sheet.

So..

How can i divide one Datatable to two Datatable.

Then i can have Datatable1 in sheet1 and Datatable2 in sheet2

any idea?.

推荐答案

检查 Pete 的答案
如何将一个数据表拆分为多个数据表? /a> [ ^ ]

Check Pete''s answer
How to Split one datatable to many datatables?[^]

仅用于循环可以帮助您分割数据集

only for loop can help you to split dataset

尝试下面的逻辑，

Try logic below,

DataTable dt = new DataTable();
        dt.Columns.Add("SNo", typeof(int));
        dt.Columns.Add("Name");
        dt.Columns.Add("Age");
        dt.Columns.Add("Address");
        for (int cnt = 1; cnt <= 110; cnt++)
        {
            DataRow dataRow;
            dataRow = dt.NewRow();
            dataRow["SNo"] = cnt;
            dataRow["Name"] = "Name" + cnt.ToString();
            dataRow["Age"] = "Age" + cnt.ToString();
            dataRow["Address"] = "Address" + cnt.ToString();
            dt.Rows.Add(dataRow);
            dt.AcceptChanges();
        }
        DataTable dtFirst = null;
        DataTable dtSecond = null;
        if (dt.Rows.Count > 100)
        {
            DataView dvFirst = new DataView(dt, "SNo<=100", "SNo", DataViewRowState.CurrentRows);
            dtFirst = dvFirst.ToTable();//This is the first datatable
            DataView dvSecond = new DataView(dt, "SNo>100", "SNo", DataViewRowState.CurrentRows);
            dtSecond = dvSecond.ToTable();//This is second datatable
        }
        dt.Dispose();

这篇关于如何将数据从一个数据表划分到两个单独的数据表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！