Winform實踐SqlCommandBuilder

    public partial class Form1 : Form
    {
        //聲明一個公用的dt
        DataTable dt=null;
        string strconn = string.Empty;
        //聲明一個公用的sql文本變數，查詢和更新都通過這個來聯通資料庫
        string sqltext = string.Empty;

        public Form1()
        {
            InitializeComponent();
            //初始設定變數
            dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
            strconn = "server=.;uid=huashanlin;pwd=123;database=TestDB";
            sqltext = "select * from T_Order";
            //載入資料
            GetDate();
        }

        private void GetDate()
        {
            using (SqlConnection conn = new SqlConnection(strconn))
            {
                SqlDataAdapter sda = new SqlDataAdapter("select * from T_User", conn);
                //這裡名為dt的Datatable必須是公用的
                dt = new DataTable();
                sda.Fill(dt);
                //綁定datagridview
                dataGridView1.DataSource = dt;
                //綁定文字框
                tB1.DataBindings.Clear();
                tB1.DataBindings.Add("text", dt, "UserID");
                tB2.DataBindings.Clear();
                tB2.DataBindings.Add("text", dt, "UserName");
            }
        }

        private void btnAlter_Click(object sender, EventArgs e)
        {
            using (SqlConnection conn = new SqlConnection(strconn))
            {
                SqlDataAdapter sda = new SqlDataAdapter("select * from T_User", conn);
                SqlCommandBuilder scb = new SqlCommandBuilder(sda);
                sda.Update(dt);
                MessageBox.Show("更新成功");
                GetDate();
            }
        }

    }