详细介绍C#该行已经属于另一个表的解决方法
程序员文章站
2022-04-21 21:37:38
...
详细介绍C#该行已经属于另一个表的解决方法
产生错误的代码:
DataTable dtContract_src = Oper.GetDataTable("select * from T_Contract where ProjectID=" + ProjectID_src + " and Flag=0", con_src); foreach (DataRow dr in dtContract_src.Rows) { String ContractID_src = dr["ContractID"].ToString(); DataTable dtContract_dst = Oper.GetDataTable("select * from T_Contract where ProjectID=" + ProjectID_src + " and ContractID=" + ContractID_src + " and Flag=0", con_dst); if (dtContract_dst.Rows.Count != 0) { impContract_exist++; continue; } dtContract_dst.Rows.Add(dr); String columns = ""; String paramss = ""; OleDbCommand updateCmd = con_dst.CreateCommand(); foreach (DataColumn dc in dtContract_dst.Columns) { if (columns == "") { columns = dc.ColumnName; paramss = "@" + dc.ColumnName; } else { columns += ", " + dc.ColumnName; paramss += ", @" + dc.ColumnName; } updateCmd.Parameters.Add(new OleDbParameter(dc.ColumnName, dc.DataType); } updateCmd.CommandText = "insert into T_Contract(" + columns + ") Values(" + paramss + ")"; updateCmd.ExecuteNonQuery(); //OleDbDataAdapter dataAdap = new OleDbDataAdapter(); //dataAdap.InsertCommand = updateCmd; //dataAdap.Update(dtContract_dst); }
错误行:
dtContract_dst.Rows.Add(dr);
解决办法:
dtContract_dst.Rows.Add(dr.ItemArray);
以上就是详细介绍C#该行已经属于另一个表的解决方法的详细内容,更多请关注其它相关文章!
上一篇: mysql服务器集群配置方法
下一篇: Java泛型详解,通俗易懂只需5分钟