Datagrid到datatable [英] Datagrid to datatable
问题描述
任何人都可以帮我将datagrisview转换为datatable类型。
我使用此代码来检索datagrid值,但它只返回NULL ....
DataTable dt = new DataTable();
dt = dataGridViewSql.DataSource as DataTable;
我读过有关使用viewstate的内容,我不知道如何...
我真的很高兴答案!
/ / mlm
public DataTable DataGridView2DataTable(DataGridView dgv, String tblName, int minRow = 0 )
{
DataTable dt = new DataTable(tblName);
// 标题栏
foreach (DataGridViewColumn列 in dgv.Columns)
{
DataColumn dc = new DataColumn(column.Name.ToString());
dt.Columns.Add(dc);
}
// 数据单元
< span class =code-keyword> for ( int i = 0 ; i < span class =code-keyword>< dgv.Rows.Count; i ++)
{
DataGridViewRow row = dgv.Rows [i];
DataRow dr = dt.NewRow();
for ( int j = 0 ; j < dgv.Columns.Count; j ++)
{
dr [j] =(row.Cells [j]。值== null )? :row.Cells [j] .Value.ToString();
}
dt.Rows.Add(dr);
}
// 与使用ExcelLibrary时的bug最小大小相关导出
for ( int i = dgv.Rows.Count; i < span class =code-keyword>< minRow; i ++)
{
DataRow dr = dt.NewRow();
for ( int j = 0 ; j < dt.Columns.Count; j ++)
{
dr [j] = ;
}
dt.Rows.Add(dr);
}
return dt;
}
来自:
http://www.maslik.com/how-to-convert-datagridview-to-datatable-using-csharp [ ^ ]
Hi,
Could anyone please help me with converting my datagrisview to datatable type.
I use this code to retrive the datagrid value, but it only returns NULL....
DataTable dt = new DataTable();
dt = dataGridViewSql.DataSource as DataTable;
I have read something about using "viewstate", bu i dont realy understand how..
I would be realy greatfull any answer!
//mlm
public DataTable DataGridView2DataTable(DataGridView dgv, String tblName, int minRow=0) { DataTable dt = new DataTable(tblName); // Header columns foreach (DataGridViewColumn column in dgv.Columns) { DataColumn dc = new DataColumn(column.Name.ToString()); dt.Columns.Add(dc); } // Data cells for (int i = 0; i < dgv.Rows.Count; i++) { DataGridViewRow row = dgv.Rows[i]; DataRow dr = dt.NewRow(); for (int j = 0; j < dgv.Columns.Count; j++) { dr[j] = (row.Cells[j].Value == null) ? "" : row.Cells[j].Value.ToString(); } dt.Rows.Add(dr); } // Related to the bug arround min size when using ExcelLibrary for export for (int i = dgv.Rows.Count; i < minRow; i++) { DataRow dr = dt.NewRow(); for (int j = 0; j < dt.Columns.Count; j++) { dr[j] = " "; } dt.Rows.Add(dr); } return dt; }
from:
http://www.maslik.com/how-to-convert-datagridview-to-datatable-using-csharp[^]
这篇关于Datagrid到datatable的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!