Convert DataView to DataTable

最新推荐文章于 2023-08-01 11:34:08 发布

原创最新推荐文章于 2023-08-01 11:34:08 发布 · 944 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#string #exception #object #null

本文介绍了一种从DataView对象创建新的DataTable的方法。通过克隆DataView中的表结构，并遍历DataView的数据行来填充新的DataTable。此过程包括处理异常情况以确保数据一致性。

public static DataTable CreateTable(DataView obDataView)
    {
        if (null == obDataView)
        {
            throw new ArgumentNullException
            ("DataView", "Invalid DataView object specified");
        }
 
        DataTable obNewDt = obDataView.Table.Clone();
        int idx = 0;
        string[] strColNames = new string[obNewDt.Columns.Count];
        foreach (DataColumn col in obNewDt.Columns)
        {
            strColNames[idx++] = col.ColumnName;
        }
 
        IEnumerator viewEnumerator = obDataView.GetEnumerator();
        while (viewEnumerator.MoveNext())
        {
            DataRowView drv = (DataRowView)viewEnumerator.Current;
            DataRow dr = obNewDt.NewRow();
            try
            {
                foreach (string strName in strColNames)
                {
                    dr[strName] = drv[strName];
                }
            }
            catch (Exception ex)
            {
                Trace.WriteLine(ex.Message);
            }
            obNewDt.Rows.Add(dr);
        }
 
        return obNewDt;
    }

public static DataTable CreateTable(DataView obDataView)
    {
        if (null == obDataView)
        {
            throw new ArgumentNullException
            ("DataView", "Invalid DataView object specified");
        }

        DataTable obNewDt = obDataView.Table.Clone();
        int idx = 0;
        string[] strColNames = new string[obNewDt.Columns.Count];
        foreach (DataColumn col in obNewDt.Columns)
        {
            strColNames[idx++] = col.ColumnName;
        }

        IEnumerator viewEnumerator = obDataView.GetEnumerator();
        while (viewEnumerator.MoveNext())
        {
            DataRowView drv = (DataRowView)viewEnumerator.Current;
            DataRow dr = obNewDt.NewRow();
            try
            {
                foreach (string strName in strColNames)
                {
                    dr[strName] = drv[strName];
                }
            }
            catch (Exception ex)
            {
                Trace.WriteLine(ex.Message);
            }
            obNewDt.Rows.Add(dr);
        }

        return obNewDt;
    }