增册改查

来源：互联网发布：学习英语的软件编辑：程序博客网时间：2024/05/13 19:47

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

//查询
   //设置dataGrid列的标题

   objSqlConnection1=new SqlConnection("Server=EP-MF5;Database=tongzongwu;uid=sa;pwd=123");
   objSqlConnection1.Open();
   sqlDataAdapter1=new SqlDataAdapter("select * from StudentsInfo", objSqlConnection1);
   sqlDataAdapter1.Fill(bojDataSet,"StudentsInfo");
   dataGrid1.DataSource=bojDataSet.Tables[0].DefaultView;

   objSqlConnection1.Close();

   //设置dataGrid列的显示内容 :比如设置BOOL字段显示成是或否

  }
//插入
  private void button1_Click(object sender, System.EventArgs e)
  {
   string insCmd="insert into StudentsInfo(StuName,stuSex,StuAddress,StuAge) values(@StuName,@stuSex,@StuAddress,@StuAge)";
   sqlDataAdapter1.InsertCommand=new SqlCommand(insCmd,objSqlConnection1);
   objSqlParameter=sqlDataAdapter1.InsertCommand.Parameters.Add("@StuName",SqlDbType.VarChar);
   objSqlParameter.SourceColumn="StuName";
   objSqlParameter.SourceVersion=DataRowVersion.Current;

   objSqlParameter=sqlDataAdapter1.InsertCommand.Parameters.Add("@stuSex",SqlDbType.VarChar);
   objSqlParameter.SourceColumn="stuSex";
   objSqlParameter.SourceVersion=DataRowVersion.Current;

   objSqlParameter=sqlDataAdapter1.InsertCommand.Parameters.Add("@StuAddress",SqlDbType.VarChar);
   objSqlParameter.SourceColumn="StuAddress";
   objSqlParameter.SourceVersion=DataRowVersion.Current;

   objSqlParameter=sqlDataAdapter1.InsertCommand.Parameters.Add("@StuAge",SqlDbType.VarChar);
   objSqlParameter.SourceColumn="StuAge";
   objSqlParameter.SourceVersion=DataRowVersion.Current;
   if(bojDataSet.HasChanges())
   {
    try
    {
     sqlDataAdapter1.Update(bojDataSet,"StudentsInfo");
     MessageBox.Show("已插入记录");

    }
    catch(SqlException ex)
    {
     MessageBox.Show(ex.Message);
    }
   }

  }
//编辑
  private void button2_Click(object sender, System.EventArgs e)
  {
   string insCmd="update StudentsInfo set StuName=@StuName,stuSex=@stuSex,StuAddress=@StuAddress,StuAge=@StuAge where ID=@ID ";
   sqlDataAdapter1.UpdateCommand=new SqlCommand(insCmd,objSqlConnection1);

   objSqlParameter=sqlDataAdapter1.UpdateCommand.Parameters.Add("@ID",SqlDbType.VarChar);
   objSqlParameter.SourceColumn="ID";
   objSqlParameter.SourceVersion=DataRowVersion.Original;
   if(bojDataSet.HasChanges())

    objSqlParameter=sqlDataAdapter1.UpdateCommand.Parameters.Add("@StuName",SqlDbType.VarChar);
   objSqlParameter.SourceColumn="StuName";
   objSqlParameter.SourceVersion=DataRowVersion.Current;

   objSqlParameter=sqlDataAdapter1.UpdateCommand.Parameters.Add("@stuSex",SqlDbType.VarChar);
   objSqlParameter.SourceColumn="stuSex";
   objSqlParameter.SourceVersion=DataRowVersion.Current;

   objSqlParameter=sqlDataAdapter1.UpdateCommand.Parameters.Add("@StuAddress",SqlDbType.VarChar);
   objSqlParameter.SourceColumn="StuAddress";
   objSqlParameter.SourceVersion=DataRowVersion.Current;

   objSqlParameter=sqlDataAdapter1.UpdateCommand.Parameters.Add("@StuAge",SqlDbType.VarChar);
   objSqlParameter.SourceColumn="StuAge";
   objSqlParameter.SourceVersion=DataRowVersion.Current;
   if(bojDataSet.HasChanges())
   {

    objDialogResult=MessageBox.Show("您想要保存这些更改吗?","确认",MessageBoxButtons.YesNo,MessageBoxIcon.Question);
    try
    {
     sqlDataAdapter1.Update(bojDataSet,"StudentsInfo");
     MessageBox.Show("数据已更新");

    }
    catch(SqlException ex)
    {
     MessageBox.Show(ex.Message);
    }
   }
   else
   {
   return;
   }
  }
//删除
  private void button4_Click(object sender, System.EventArgs e)
  {
   string insCmd="delete from StudentsInfo where ID=@ID";
   sqlDataAdapter1.DeleteCommand=new SqlCommand(insCmd,objSqlConnection1);

   objSqlParameter=sqlDataAdapter1.DeleteCommand.Parameters.Add("@ID",SqlDbType.VarChar);
   objSqlParameter.SourceColumn="ID";
   objSqlParameter.SourceVersion=DataRowVersion.Original;

   objDialogResult=MessageBox.Show("您确定要删除当前记录吗?","确认",MessageBoxButtons.YesNo,MessageBoxIcon.Question);
   if(objDialogResult==DialogResult.Yes)
   {
    try
    {
     bojDataSet.Tables[0].Rows[dataGrid1.CurrentRowIndex].Delete();
     sqlDataAdapter1.Update(bojDataSet,"StudentsInfo");
     MessageBox.Show("已删除");
    }
    catch
     (SqlException ex){
    MessageBox.Show(ex.Message);
    }
   }
  }