同按钮有插入和修改

来源：互联网发布：恺英网络阿拉德之怒编辑：程序博客网时间：2024/04/29 22:13

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;

namespace studentsSelect
{
/// <summary>
/// Form1 的摘要说明。
/// </summary>
public class frmStudents : System.Windows.Forms.Form
{
  private System.Windows.Forms.Button btnAdd;
  private System.Windows.Forms.Button btnExie;
  private System.Windows.Forms.Button btnDelete;
  private System.Windows.Forms.Button btnBs;
  private System.Windows.Forms.Button btnExit;
  SqlConnection objSqlConnection1;
        SqlDataAdapter objSqlDataAdapter1;
         DataSet objDataSet=new DataSet();
  SqlParameter objSqlParameter;
  DialogResult objDialogResult;
  private System.Windows.Forms.DataGrid dbgStuden;
  SqlCommand objSqlCommand;

  /// <summary>
  /// 必需的设计器变量。
  /// </summary>
  private System.ComponentModel.Container components = null;

  public frmStudents()
  {
   //
   // Windows 窗体设计器支持所必需的
   //
   InitializeComponent();

   //
   // TODO: 在 InitializeComponent 调用后添加任何构造函数代码
   //
  }

  /// <summary>
  /// 清理所有正在使用的资源。
  /// </summary>
  protected override void Dispose( bool disposing )
  {
   if( disposing )
   {
    if (components != null)
    {
     components.Dispose();
    }
   }
   base.Dispose( disposing );
  }

  #region Windows 窗体设计器生成的代码
  /// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {
   this.dbgStuden = new System.Windows.Forms.DataGrid();
   this.btnAdd = new System.Windows.Forms.Button();
   this.btnExie = new System.Windows.Forms.Button();
   this.btnDelete = new System.Windows.Forms.Button();
   this.btnBs = new System.Windows.Forms.Button();
   this.btnExit = new System.Windows.Forms.Button();
   ((System.ComponentModel.ISupportInitialize)(this.dbgStuden)).BeginInit();
   this.SuspendLayout();
   //
   // dbgStuden
   //
   this.dbgStuden.DataMember = "";
   this.dbgStuden.HeaderForeColor = System.Drawing.SystemColors.ControlText;
   this.dbgStuden.Location = new System.Drawing.Point(0, 0);
   this.dbgStuden.Name = "dbgStuden";
   this.dbgStuden.ReadOnly = true;
   this.dbgStuden.Size = new System.Drawing.Size(704, 304);
   this.dbgStuden.TabIndex = 0;
   //
   // btnAdd
   //
   this.btnAdd.Location = new System.Drawing.Point(80, 328);
   this.btnAdd.Name = "btnAdd";
   this.btnAdd.Size = new System.Drawing.Size(75, 32);
   this.btnAdd.TabIndex = 1;
   this.btnAdd.Text = "加载";
   this.btnAdd.Click += new System.EventHandler(this.btnAdd_Click);
   //
   // btnExie
   //
   this.btnExie.Location = new System.Drawing.Point(200, 328);
   this.btnExie.Name = "btnExie";
   this.btnExie.Size = new System.Drawing.Size(75, 32);
   this.btnExie.TabIndex = 2;
   this.btnExie.Text = "编辑";
   this.btnExie.Click += new System.EventHandler(this.btnExie_Click);
   //
   // btnDelete
   //
   this.btnDelete.Location = new System.Drawing.Point(312, 328);
   this.btnDelete.Name = "btnDelete";
   this.btnDelete.Size = new System.Drawing.Size(75, 32);
   this.btnDelete.TabIndex = 3;
   this.btnDelete.Text = "删除";
   this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click);
   //
   // btnBs
   //
   this.btnBs.Location = new System.Drawing.Point(424, 328);
   this.btnBs.Name = "btnBs";
   this.btnBs.Size = new System.Drawing.Size(75, 32);
   this.btnBs.TabIndex = 4;
   this.btnBs.Text = "保存";
   this.btnBs.Click += new System.EventHandler(this.btnBs_Click);
   //
   // btnExit
   //
   this.btnExit.Location = new System.Drawing.Point(536, 328);
   this.btnExit.Name = "btnExit";
   this.btnExit.Size = new System.Drawing.Size(75, 32);
   this.btnExit.TabIndex = 5;
   this.btnExit.Text = "退出";
   this.btnExit.Click += new System.EventHandler(this.btnExit_Click);
   //
   // frmStudents
   //
   this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
   this.ClientSize = new System.Drawing.Size(696, 390);
   this.Controls.Add(this.btnExit);
   this.Controls.Add(this.btnBs);
   this.Controls.Add(this.btnDelete);
   this.Controls.Add(this.btnExie);
   this.Controls.Add(this.btnAdd);
   this.Controls.Add(this.dbgStuden);
   this.Name = "frmStudents";
   this.Text = "学员信息管理";
   this.Load += new System.EventHandler(this.frmStudents_Load);
   ((System.ComponentModel.ISupportInitialize)(this.dbgStuden)).EndInit();
   this.ResumeLayout(false);

}
#endregion

  /// <summary>
  /// 应用程序的主入口点。
  /// </summary>
  [STAThread]
  static void Main()
  {
   Application.Run(new frmStudents());
  }

  private void frmStudents_Load(object sender, System.EventArgs e)
  {
   objSqlConnection1=new SqlConnection("Server=127.0.0.1;Database=StudentsDB;uid=sa;pwd=123");

  }

  private void btnAdd_Click(object sender, System.EventArgs e)
  {
   objDataSet.Tables.Clear();
   objSqlConnection1.Open();
   objSqlDataAdapter1=new SqlDataAdapter("select * from StudentsInfo", objSqlConnection1);
   objSqlDataAdapter1.Fill(objDataSet,"StudentsInfo");

   dbgStuden.DataSource=objDataSet.Tables[0].DefaultView;
   objSqlConnection1.Close();
  }

  private void btnExie_Click(object sender, System.EventArgs e)
  {
    this.dbgStuden.ReadOnly = false;
  }

  private void btnBs_Click(object sender, System.EventArgs e)
  {
   //修改记录
   string upCmd="update StudentsInfo set StuName=@StuName,stuSex=@stuSex,StuAddress=@StuAddress,StuAge=@StuAge where ID=@ID ";
   objSqlDataAdapter1.UpdateCommand=new SqlCommand(upCmd,objSqlConnection1);

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

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

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

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

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

   //添加记录
   string insCmd="insert into StudentsInfo(StuName,stuSex,StuAddress,StuAge) values(@StuName,@stuSex,@StuAddress,@StuAge)";
   objSqlDataAdapter1.InsertCommand=new SqlCommand(insCmd,objSqlConnection1);
   objSqlParameter=objSqlDataAdapter1.InsertCommand.Parameters.Add("@StuName",SqlDbType.VarChar);
   objSqlParameter.SourceColumn="StuName";
   objSqlParameter.SourceVersion=DataRowVersion.Current;

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

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

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

if(objDataSet.HasChanges())
{

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

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

  }
  private void tongUpdate()
  {
   string updCmd="update StudentsInfo set StuName=@StuName,stuSex=@stuSex,StuAddress=@StuAddress,StuAge=@StuAge where ID=@ID ";
   objSqlDataAdapter1.UpdateCommand=new SqlCommand(updCmd,objSqlConnection1);

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

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

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

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

   }
  }
  private void tongAdd()
  {
   string insCmd="insert into StudentsInfo(StuName,stuSex,StuAddress,StuAge) values(@StuName,@stuSex,@StuAddress,@StuAge)";
   objSqlDataAdapter1.InsertCommand=new SqlCommand(insCmd,objSqlConnection1);
   objSqlParameter=objSqlDataAdapter1.InsertCommand.Parameters.Add("@StuName",SqlDbType.VarChar);
   objSqlParameter.SourceColumn="StuName";
   objSqlParameter.SourceVersion=DataRowVersion.Current;

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

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

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

    }
   }
  }

  private void btnDelete_Click(object sender, System.EventArgs e)
  {
   string insCmd="delete from StudentsInfo where ID=@ID";
   objSqlDataAdapter1.DeleteCommand=new SqlCommand(insCmd,objSqlConnection1);

   objSqlParameter=objSqlDataAdapter1.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
    {
     objDataSet.Tables[0].Rows[dbgStuden.CurrentRowIndex].Delete();
     objSqlDataAdapter1.Update(objDataSet,"StudentsInfo");
     MessageBox.Show("已删除");
    }
    catch
     (SqlException ex)
    {
     MessageBox.Show(ex.Message);
    }
   }
  }

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

   Application.Exit();
  }

}
}