.NET 更新数据库

最新推荐文章于 2024-09-16 08:56:24 发布

faith_zerg

最新推荐文章于 2024-09-16 08:56:24 发布

阅读量1.7k

点赞数

分类专栏： C#NET 文章标签： .net datagrid cmd security dataset button

本文链接：https://blog.csdn.net/faith_zerg/article/details/1627233

版权

C#NET 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

private void button1_Click(object sender, System.EventArgs e)
  {
   con=new SqlConnection("workstation id=ZERG1;packet size=4096;integrated security=SSPI;data source=ZERG1;persist security info=False;initial catalog=Northwind");
   cmd=new SqlCommand("select * from emp",con);
   da=new SqlDataAdapter(cmd);
   ds=new DataSet();
   da.Fill(ds,"employee");
   dataGrid1.DataSource=ds;
   dataGrid1.DataMember="employee";

  }

  private void button2_Click(object sender, System.EventArgs e)
  {

   da.InsertCommand=insertcommand();
   da.UpdateCommand=updatecommand();
   da.DeleteCommand=deletecommand();

da.Update(ds.Tables["employee"]);
}

  private SqlCommand insertcommand()
  {
   SqlCommand cmd=new SqlCommand("insert into emp(lastname, firstname) values(@lastname, @firstname)",con);

   SqlParameter sp1=cmd.Parameters.Add("@lastname",SqlDbType.VarChar);
   sp1.SourceColumn="lastname"; //设置要更新的列
   sp1.SourceVersion=DataRowVersion.Current; //设置要更新的值的版本

   SqlParameter sp2=cmd.Parameters.Add("@firstname",SqlDbType.VarChar);
   sp2.SourceColumn="firstname";
   sp2.SourceVersion=DataRowVersion.Current;

return cmd;
}

  private SqlCommand updatecommand()
  {
   SqlCommand cmd=new SqlCommand("update emp set lastname=@lastname,firstname=@firstname where employeeid=@employeeid",con);

   SqlParameter sp1=cmd.Parameters.Add("@employeeid",SqlDbType.Int);
   sp1.SourceColumn="employeeid"; //设置要更新的列
   sp1.SourceVersion=DataRowVersion.Original; //设置要更新的值的版本

   SqlParameter sp2=cmd.Parameters.Add("@lastname",SqlDbType.VarChar);
   sp2.SourceColumn="lastname"; //设置要更新的列
   sp2.SourceVersion=DataRowVersion.Current; //设置要更新的值的版本

   SqlParameter sp3=cmd.Parameters.Add("@firstname",SqlDbType.VarChar);
   sp3.SourceColumn="firstname";
   sp3.SourceVersion=DataRowVersion.Current;

return cmd;
}

  private SqlCommand deletecommand()
  {
   SqlCommand cmd=new SqlCommand("delete from emp where employeeid=@employeeid",con);

return cmd;
}