DataTable dt = new DataTable();
把DataGridView控件数据,转成DataTable
for (int count = 0; count < DataGridView.Columns.Count; count++)
{
DataColumn dc = new DataColumn(DataGridView.Columns[count].Name.ToString());
dt.Columns.Add(dc);
}
for (int count = 0; count < DataGridView.Rows.Count; count++)
{
DataRow dr = dt.NewRow();
for (int countsub = 0; countsub < DataGridView.Columns.Count; countsub++)
{
dr[countsub] = Convert.ToString(DataGridView.Rows[count].Cells[countsub].Value);
}
dt.Rows.Add(dr);
}
把DataGridView控件数据,转成DataTable
for (int count = 0; count < DataGridView.Columns.Count; count++)
{
DataColumn dc = new DataColumn(DataGridView.Columns[count].Name.ToString());
dt.Columns.Add(dc);
}
for (int count = 0; count < DataGridView.Rows.Count; count++)
{
DataRow dr = dt.NewRow();
for (int countsub = 0; countsub < DataGridView.Columns.Count; countsub++)
{
dr[countsub] = Convert.ToString(DataGridView.Rows[count].Cells[countsub].Value);
}
dt.Rows.Add(dr);
}