protected void Button2_Click(object sender, EventArgs e)
{
SqlConnection conn2 = new SqlConnection("data source=(local);database=Northwind;user=sa; password=8888"); //創(chuàng)建連接對(duì)象
SqlDataAdapter da2 = new SqlDataAdapter();
//適配器對(duì)象的查詢(xún)命令
SqlCommand cmdSel=new SqlCommand("select RegionID, RegionDescription from Region", conn2); //創(chuàng)建DataAdapter(數(shù)據(jù)適配器)
da2.SelectCommand = cmdSel;
//適配器對(duì)象的更新命令
SqlCommand cmdUpdate = new SqlCommand("update Region set RegionDescription ＝@RegionDescription where RegionID = @RegionID", conn2);
SqlParameter paramID = new SqlParameter("@RegionID",SqlDbType.Int);
paramID.SourceColumn = "RegionID"; //數(shù)據(jù)值對(duì)應(yīng)的字段
paramID.SourceVersion = DataRowVersion.Original;　//數(shù)據(jù)值將使用初始版本的數(shù)值
cmdUpdate.Parameters.Add("@RegionDescription",SqlDbType.NChar,50,"RegionDescription");
cmdUpdate.Parameters.Add(paramID);
da2.UpdateCommand = cmdUpdate; //
//適配器對(duì)象的添加命令
SqlCommand cmdInsert = new SqlCommand("insert into Region(RegionDescription) values (@RegionDescription)", conn2);
cmdInsert.Parameters.Add("@RegionID", SqlDbType.Int, 4, "RegionID");
cmdInsert.Parameters.Add("@RegionDescription", SqlDbType.NChar, 50, "RegionDescription");
da2.InsertCommand = cmdInsert;
//適配器對(duì)象的刪除命令
SqlCommand cmdDel = new SqlCommand("delete * from Region where http://www.ahfyzs.com/mailto:RegionID=@RegionID", conn2);
SqlParameter paramDelID = new SqlParameter("@RegionID", SqlDbType.Int);
paramDelID.SourceColumn = "RegionID";
paramDelID.SourceVersion = DataRowVersion.Original;
cmdDel.Parameters.Add(paramDelID);
da2.DeleteCommand = cmdDel;

DataSet ds2 = new DataSet(); //創(chuàng)建DataSet(數(shù)據(jù)集)
da2.Fill(ds2,"Region"); //使用數(shù)據(jù)適配器填充數(shù)據(jù)集

GridView1.DataSource = ds2; //顯示，綁定
//GridView1.DataMember = "mybaobiao";
GridView1.DataBind();

//添加數(shù)據(jù)
DataRow addrow = ds2.Tables[0].NewRow();
addrow[1] = "碧海灣8";
ds2.Tables[0].Rows.Add(addrow);
da2.Update(ds2, "Region");

//修改數(shù)據(jù)
DataRow editrow = ds2.Tables["Region"].Rows[0];
//editrow.BeginEdit();
editrow["RegionDescription"] = "北京9北京9北京9";
//editrow.EndEdit();
GridView1.DataSource = ds2; //顯示，綁定
GridView1.DataBind();
da2.Update(ds2, "Region");

//刪除數(shù)據(jù)
DataRow editrow1 = ds2.Tables["Region"].Rows[3];
editrow1.Delete();
GridView1.DataSource = ds2; //顯示，綁定
GridView1.DataBind();
//da2.Update(ds2,"Region")
}