C# datatable增加一列，并赋值

Dear 丶 2022-08-29 10:45 404阅读 0赞 
  1. sql = "select plandate as 日期,number as 数量,num1 as 开始编号,pipeline as 流水编号,dayornight as 白晚班1,AorS as 层区名称,description as 说明 from gq_sec where factory='" + f.current_factory + "'and gq_pri_id=" + id + " and diff=0 order by 日期 desc";
  2. MySqlDataAdapter comm = new MySqlDataAdapter(sql, conn);
  3. DataTable ds = new DataTable();
  4. comm.Fill(ds);
  6. ds.Columns.Add(new DataColumn() {
  7.      ColumnName = "白晚班", DataType = typeof(String) });
  8. ds.Columns["白晚班"].SetOrdinal(5);//由于dayornight数据类型为int，当该列在有数据的情况下转不了string，新增一列，原来一列隐藏
  9. for (int i = 0; i < ds.Rows.Count; i++)
  10. {
  12.     if (ds.Rows[i]["白晚班1"].ToString() == "1") ds.Rows[i]["白晚班"] = "白班";
  13.     else if (ds.Rows[i]["白晚班1"].ToString() == "2") ds.Rows[i]["白晚班"] = "晚班";
  14. }
  15. dataGridView1.DataSource = ds;
  16. dataGridView1.Columns["白晚班1"].Visible = false;

发表评论

表情：
评论列表 （有 0 条评论，404人围观）

还没有评论，来说两句吧...

相关阅读