详细介绍C#该行已经属于另一个表的解决方法


本文摘自PHP中文网,作者黄舟,侵删。

详细介绍C#该行已经属于另一个表的解决方法

产生错误的代码:

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

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);

 

                            }

阅读剩余部分

相关阅读 >>

C#实现char字符数组与字符串相互转换的方法详解

C#中如何取绝对值函数的方法详解

C#教程】C# 多态性

C#基于正则表达式如何删除字符串中数字或非数字的方法详解

分享多线程下C#如何保证线程安全

详解C#不登录电脑启动程序(图文)

详细介绍C#中调用formatmessage api

C#基础入门-关键字的介绍

C# 清除html标签标记

详细介绍用C#描述数据结构3:arraylist的图文代码

更多相关阅读请进入《C#》频道 >>




打赏

取消

感谢您的支持,我会继续努力的!

扫码支持
扫码打赏,您说多少就多少

打开支付宝扫一扫,即可进行扫码打赏哦

分享从这里开始,精彩与您同在

评论

管理员已关闭评论功能...