DataTable dtInsert = null;
public DataTable GetDgvToTable(DataGridView dgv)
{
//将dataGridView的数据全部放到DataTable
DataTable dt = new DataTable();
//强制转换所有列
for (int count = 0; count < dgv.Columns.Count; count++)// dgv.Columns.Count是所有列
{
DataColumn dc = new DataColumn(dgv.Columns[count].Name.ToString());
dt.Columns.Add(dc);
}
//将所有数据放到DataTable
for (int count = 0; count < dgv.Rows.Count; count++)//dgv.Rows.Count所有列数
{
DataRow dr = dt.NewRow();
for (int countsub = 0; countsub < dgv.Columns.Count; countsub++)
{
dr[countsub] = Convert.ToString(dgv.Rows[count].Cel
public DataTable GetDgvToTable(DataGridView dgv)
{
//将dataGridView的数据全部放到DataTable
DataTable dt = new DataTable();
//强制转换所有列
for (int count = 0; count < dgv.Columns.Count; count++)// dgv.Columns.Count是所有列
{
DataColumn dc = new DataColumn(dgv.Columns[count].Name.ToString());
dt.Columns.Add(dc);
}
//将所有数据放到DataTable
for (int count = 0; count < dgv.Rows.Count; count++)//dgv.Rows.Count所有列数
{
DataRow dr = dt.NewRow();
for (int countsub = 0; countsub < dgv.Columns.Count; countsub++)
{
dr[countsub] = Convert.ToString(dgv.Rows[count].Cel