C#里如何把一个DataTable的数据追加进数据库里的某个表

方法一

DataTable table = new DataTable();
            //TODO: init table...
            string connStr = "user id=" + dbInfo.UserName + ";data source=" + dbInfo.DBServerIP + ";persist security info=False;initial catalog=" + dbInfo.DatabaseName + ";password=" + dbInfo.Password;
            SqlConnection conn = new SqlConnection(connStr);
            conn.Open();
            SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(conn);
            sqlBulkCopy.DestinationTableName = dbInfo.TableName;
            sqlBulkCopy.WriteToServer(table);
            sqlBulkCopy.Close();

方法二

DataTable table = new DataTable();
            //TODO: init table...

            string connStr = "user id=" + dbInfo.UserName + ";data source=" + dbInfo.DBServerIP + ";persist security info=False;initial catalog=" + dbInfo.DatabaseName + ";password=" + dbInfo.Password;
            DataTable dt = new DataTable();
            SqlConnection conn = new SqlConnection(connStr);
            SqlCommand cmd = new SqlCommand(string.Format("select * from {0} where 1=2", dbInfo.TableName), conn);
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            SqlCommandBuilder Builder = new SqlCommandBuilder(sda);
            sda.Fill(dt);

            DataRow addRow = null;
            foreach (DataRow row in table.Rows)
            {
                addRow = dt.NewRow();
                for (int i = 0; i < table.Columns.Count; i++)
                {
                    addRow[i] = row[i];
                }
                dt.Rows.Add(addRow);
            }

            sda.Update(dt);


总结

1. 仅仅有 Insert ? 那么用 SqlBulkCopy.
2. Insert/Update/Delete ? 那么用 DataAdapter.Update.


发布了142 篇原创文章 · 获赞 46 · 访问量 22万+

没有更多推荐了,返回首页

©️2019 CSDN 皮肤主题: 大白 设计师: CSDN官方博客

分享到微信朋友圈

×

扫一扫,手机浏览