SQL整体更新的方法

假如在项目中遇到用户在客户端编辑数据,添加数据.SQL整体更新到数据库里面，应该怎么做呢？接下来的SQL server内容就将教您如何进行SQL整体更新，供您参考。

数据库结构:

DataSet ds=new DataSet();读取数据      private void button1_Click(object sender, System.EventArgs e)          {              //              string str_Conn="workstation id=JHTCHINA;packet size=4096;user id=sa;initial catalog=master;persist security info=False";              try              {                  SqlConnection objConn=new SqlConnection(str_Conn);                  string str_sql="select * from Test_Base";                  SqlCommand objComm=new SqlCommand(str_sql,objConn);                  SqlDataAdapter objAdapter=new SqlDataAdapter(objComm);                                 objAdapter.Fill(ds,"Test_Base");                  dataGrid1.DataSource=ds;              }              catch (Exception exc)              {                  MessageBox.Show(exc.Message);              }          } 

CREATE TABLE [Test_Base] (

    [CodeZZB] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,

    [InterName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,

    [Guid] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_LoginPerson_Guid] DEFAULT (newid()),

    CONSTRAINT [PK_Test_Base] PRIMARY KEY  CLUSTERED

    (

        [CodeZZB]

    )  ON [PRIMARY]

) ON [PRIMARY]

GO

定义 全局DataSet

DataSet ds=new DataSet();读取数据      private void button1_Click(object sender, System.EventArgs e)          {              //              string str_Conn="workstation id=JHTCHINA;packet size=4096;user id=sa;initial catalog=master;persist security info=False";              try              {                  SqlConnection objConn=new SqlConnection(str_Conn);                  string str_sql="select * from Test_Base";                  SqlCommand objComm=new SqlCommand(str_sql,objConn);                  SqlDataAdapter objAdapter=new SqlDataAdapter(objComm);                                 objAdapter.Fill(ds,"Test_Base");                  dataGrid1.DataSource=ds;              }              catch (Exception exc)              {                  MessageBox.Show(exc.Message);              }          } 

编辑添加dataGrid以后更新数据

private void button2_Click(object sender, System.EventArgs e)          {                          try              {                                  //这里ds.Table[0]里面的数据已经改变                  string str_Conn="workstation id=JHTCHINA;packet size=4096;user id=sa;initial catalog=master;persist security info=False";                  //整体把修改的数据更新到数据库里面                  SqlConnection objConn=new SqlConnection(str_Conn);                  string str_sql="select * from Test_Base";                  SqlCommand objComm=new SqlCommand(str_sql,objConn);                   SqlDataAdapter objAdapter=new SqlDataAdapter(objComm);                  SqlCommandBuilder updataBulid=new SqlCommandBuilder(objAdapter);                  objAdapter.Update(ds,"Test_Base");                                    MessageBox.Show("OK");               }              catch  (Exception exc)              {                  MessageBox.Show(exc.Message);              }          }  

运行通过

假如是SQL整体更新添加,在数据读取的时候

string str_sql="select * from Test_Base where 1=2";

一句代码就可以了