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);
}
}
}