C#中的SqlCommandBuilder用法

最新推荐文章于 2019-01-22 11:37:00 发布

听取蛙声一片

最新推荐文章于 2019-01-22 11:37:00 发布

阅读量1.5k

点赞数

分类专栏： C# 文章标签： sql

本文链接：https://blog.csdn.net/qq_42885712/article/details/86516386

版权

C# 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

using System;
	using System.Collections.Generic;
	using System.ComponentModel;
	using System.Configuration;
	using System.Data;
	using System.Data.SqlClient;
	using System.Drawing;
	using System.Linq;
	using System.Text;
	using System.Threading.Tasks;
	using System.Windows.Forms;

namespace AdapterTest
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
    #region 保存
    private void btnSave_Click(object sender, EventArgs e)
    {
        string sqlConn = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
        //修改的sql 一定要与查询的sql一致
        string sql = "select UserID,UserName,UserPwd from UserInfo2";
        using (SqlDataAdapter adapter = new SqlDataAdapter(sql,sqlConn))
        {
            DataTable dt = this.dataGridView.DataSource as DataTable;
            //把修改完的内存表dt  变化映射到数据库的表中去
            //SqlCommandBuilder 帮助adapter生成CURD sqlCommand
            using (SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(adapter))
            {
                adapter.Update(dt);
                
            }
        }
    } 
    #endregion

     #region 加载数据
    private void LoadData()
    {
        string sqlConn = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
        string sql = "select UserID,UserName,UserPwd from UserInfo2";
        using (SqlDataAdapter adapter = new SqlDataAdapter(sql,sqlConn))
        {
            DataTable tb = new DataTable();
            adapter.Fill(tb);
            this.dataGridView.DataSource = tb;
        }
    } 
    #endregion

    private void Form1_Load(object sender, EventArgs e)
    {
        LoadData();
    }
}

}