dataGridView中值赋值给DataTable

最新推荐文章于 2023-06-27 19:14:42 发布

brian0031

最新推荐文章于 2023-06-27 19:14:42 发布

阅读量1.6k

点赞数

分类专栏： C# 赋值 dataGridView datatable Expression 文章标签： textbox sql object string

本文链接：https://blog.youkuaiyun.com/brian0031/article/details/6594382

版权

C# 同时被 3 个专栏收录

117 篇文章

订阅专栏

dataGridView

37 篇文章

订阅专栏

datatable

17 篇文章

订阅专栏

DataTable dtsve = new DataTable();

private void toolStripButton6_Click(object sender, EventArgs e) //保存
{
   if (dataGridView1.Rows.Count > 0)
   {
   string str_sql = "SELECT * FROM MaterialDemand a WHERE 1=2"; //只获取表结构,但无表内容
   dtsve = SQL.command(str_sql).Tables[0];
   for (int i = 0; i < dataGridView1.Rows.Count; i++)
   {
   DataRow drow = dtsve.NewRow();
   drow["MaterialCode"] = dataGridView1.Rows[i].Cells[0].Value.ToString().Trim();
   drow["CreateDate"] = DateTime.Now.ToString("yyyy-MM-dd").Trim();
   dtsve.Rows.Add(drow);

}

   DataRow drow = dtsve.NewRow();
   dtsve.Rows.Add(drow);
   dtsve.Columns["Applicant_name"].Expression = "'" + textBox1.Text.Trim() + "'";
   dtsve.Columns["DepartmentCode"].Expression = "'" + textBox2.Text.Trim() + "'";
   }
}