datagridview 更新数据库

     public partial class Form1 : Form

       {

        #region Form1数据成员

        private DataTable DT = new DataTable();

        private SqlDataAdapter DA = new SqlDataAdapter();

        #endregion

        #region  Form1构造函数

        public Form1()

        {

            InitializeComponent();

        }

        #endregion

        #region  连接数据库显示数据

        private void Form1_Load(object sender, EventArgs e)

        {

            SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=tt;Persist Security Info=True;User ID=sa;Password=sunlang0924");
            
            SqlCommand SCD = new SqlCommand("select * from tab", conn);

            DA.SelectCommand = SCD;

            DA.Fill(DT);

            dataGridView1.DataSource = DT;

        }

        #endregion

        #region  使用Update更新数据库

        private void button1_Click(object sender, EventArgs e)

        {

            try

            {

                SqlCommandBuilder SCB = new SqlCommandBuilder(DA);            

                DA.Update(DT);

            }

            catch (System.Exception ex)

            {

                MessageBox.Show(ex.ToString());

                return;

            }

            MessageBox.Show("更新成功!");

        }

#endregion