using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Text; using System.Windows.Forms; namespace DataSource ... {publicpartialclassForm1:Form...{publicForm1()...{InitializeComponent();}privateDataSetds=newDataSet();privateSqlConnectionconn=null;privateSqlDataAdapterda=null;privateconststringDRIVER="server=.;database=northwind;uid=sa;pwd=sa";privateconststringsql_select="select*fromregion";/**//***此方法为将数据库northwind中的region表的数据查询出来并放入DataSet中**/privatevoidForm1_Load(objectsender,EventArgse)...{conn=newSqlConnection(DRIVER);da=newSqlDataAdapter(sql_select,conn);da.Fill(ds,"table");this.dataGridView1.DataSource=ds.Tables["table"].DefaultView;}privateboolBtnInsert()//此方法作用于添加...{da.InsertCommand=conn.CreateCommand();da.InsertCommand.CommandText="insertintoregionvalues(@id,@ption)";da.InsertCommand.Parameters.Add("@id",SqlDbType.Int,4,"regionid");da.InsertCommand.Parameters.Add("@ption",SqlDbType.VarChar,10,"regiondescription");intcount=da.Update(ds);boolresult=count>0?true:false;returnresult;}privatevoidbutton1_Click(objectsender,EventArgse)...{if(this.BtnInsert())//调用此方法...{MessageBox.Show("添加成功!");}else...{MessageBox.Show("添加失败!");}}privateboolBtnDelect()//此方法作用于删除...{SqlParametersp=newSqlParameter();da.DeleteCommand=conn.CreateCommand();da.DeleteCommand.CommandText="deleteregionwhereregionid=@id";sp=da.DeleteCommand.Parameters.Add("@id",SqlDbType.Int,4,"regionid");sp.SourceVersion=DataRowVersion.Original;ds.Tables["table"].Rows[this.dataGridView1.CurrentRow.Index].Delete();intcount=da.Update(ds);boolresult=count>0?true:false;returnresult;}privatevoidbutton2_Click(objectsender,EventArgse)...{if(this.BtnDelect())//调用删除方法...{MessageBox.Show("删除成功!");}else...{MessageBox.Show("删除失败!");}}privateboolBtnUpdate()//此方法作用于修改...{SqlParametersp=newSqlParameter();da.UpdateCommand=conn.CreateCommand();da.UpdateCommand.CommandText="updateregionsetregionid=@id,regiondescription=@ptionwhereregionid=@oldid";da.UpdateCommand.Parameters.Add("@id",SqlDbType.Int,4,"regionid");da.UpdateCommand.Parameters.Add("@ption",SqlDbType.VarChar,10,"regiondescription");sp=da.UpdateCommand.Parameters.Add("@oldid",SqlDbType.Int,4,"regionid");sp.SourceVersion=DataRowVersion.Original;intcount=da.Update(ds);boolresult=count>0?true:false;returnresult;}privatevoidbutton3_Click(objectsender,EventArgse)...{if(this.BtnUpdate())//调用修改方法...{MessageBox.Show("修改成功!");}else...{MessageBox.Show("修改失败!");}}}}