DataTable dtsve = new DataTable();
{
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() + "'";
}
}