詳細介紹C#該行已經屬於另一個表的解決方案

詳細介紹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);