将DataGridView转换为DataTable

来源:互联网 发布:appium python client 编辑:程序博客网 时间:2024/05/29 18:29

本文转自:http://www.cnblogs.com/linji/archive/2012/10/11/2719471.html


将dataGridView数据转成DataTable

如已绑定过数据源:

DataTable dt = (dataGridView1.DataSource as DataTable)

 

 

如未绑定过数据源:

复制代码
     public DataTable GetDgvToTable(DataGridView dgv)        {            DataTable dt = new DataTable();            // 列强制转换            for (int count = 0; count < dgv.Columns.Count; count++)            {                DataColumn dc = new DataColumn(dgv.Columns[count].Name.ToString());                dt.Columns.Add(dc);            }            // 循环行            for (int count = 0; count < dgv.Rows.Count; count++)            {                DataRow dr = dt.NewRow();                for (int countsub = 0; countsub < dgv.Columns.Count; countsub++)                {                    dr[countsub] = Convert.ToString(dgv.Rows[count].Cells[countsub].Value);                }                dt.Rows.Add(dr);            }            return dt;        }

0 0
原创粉丝点击