string sqlname = "select * from workreport order by MineId";
SqlDataAdapter adapter = new SqlDataAdapter(sqlname,conn);
DataSet ds = new DataSet();
adapter.Fill(ds, "table_1");
DataRow dr = ds.Tables["table_1"].NewRow();//定义DataTable中的一行
dr[MineId] = MineId;//错误开始行
dr[CardId] = CardId;
dr[time1] = time1;
dr[time2] = time2;
dr[hours] = hours;
dr[workcount] = workcount;
dr[AddId] = AddId;
dr[Dates] = Dates;
ds.Tables["table_1"].Rows.Add(dr);
adapter.Update(ds, "table_1");
错误如下:
System.ArgumentException: 列“14058116001”不属于表 table_1。
在 System.Data.DataRow.GetDataColumn(String columnName)
在 System.Data.DataRow.set_Item(String columnName, Object value)
SqlDataAdapter adapter = new SqlDataAdapter(sqlname,conn);
DataSet ds = new DataSet();
adapter.Fill(ds, "table_1");
DataRow dr = ds.Tables["table_1"].NewRow();//定义DataTable中的一行
dr[MineId] = MineId;//错误开始行
dr[CardId] = CardId;
dr[time1] = time1;
dr[time2] = time2;
dr[hours] = hours;
dr[workcount] = workcount;
dr[AddId] = AddId;
dr[Dates] = Dates;
ds.Tables["table_1"].Rows.Add(dr);
adapter.Update(ds, "table_1");
错误如下:
System.ArgumentException: 列“14058116001”不属于表 table_1。
在 System.Data.DataRow.GetDataColumn(String columnName)
在 System.Data.DataRow.set_Item(String columnName, Object value)
//加上引号试下
MineId是字段名吧!应该这样写啊!
MineId=14058116001
System.ArgumentException: 列“14058116001”不属于表 table_1。
错误信息的意思是在table_1中找不到14058116001列。