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("@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;
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
{
}
}
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("@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())
{
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();
}
}
}