/// <summary>
/// 绑定DataGridView数据到DataTable
/// </summary>
/// <param name="dgv">复制数据的DataGridView</param>
/// <returns>返回的绑定数据后的DataTable</returns>
public static DataTable GetDgvToTable(DataGridView dgv)
{
DataTable dt = new DataTable("test");
// 列强制转换
for (int count = 0; count < dgv.Columns.Count; count++)
{
if (dgv.Columns[count].Name.ToString()!=null )
{
DataColumn dc = new DataColumn(dgv.Columns[count].Name.ToString());
dt.Columns.Add(dc);
}
}
// 循环行
for (int count = 0; count < dgv.Rows.Count; count++)
{
bool b = false;
for (int i = 0; i < dgv.Columns.Count; i++)
{
if (count == dgv.Rows.Count - 1)
{
b = false;
break;
}
//string str = dgv.Rows[6].Cells[0].Value.ToString();
if (dgv.Rows[count].Cells[i].Value.ToString() != "")
{
b = true;
break;
}
}
if (b)
{
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;
}
关于DataGridView的简单使用
最新推荐文章于 2024-06-14 15:55:33 发布