SqlDataAdapter sqlAdatper=new SqlDataAdapter();

sqlAdatper.SelectCommand=selectCmd;

DataSet ds=new DataSet();

con.Open();

sqlAdatper.Fill(ds,"publishers");

con.Close();



SqlCommand updateCmd=con.CreateCommand();

updateCmd.CommandText="update publishers set pub_name=@pubname,city=@city,state=@state,country=@country where pub_id=@pub_id";

SqlParameter PubNamePar=new SqlParameter("@pubname",SqlDbType.VarChar,40,"pub_name");

updateCmd.Parameters.Add(PubNamePar);

SqlParameter CityPar=new SqlParameter("@city",SqlDbType.VarChar,20,"city");

updateCmd.Parameters.Add(CityPar);

SqlParameter StatePar=new SqlParameter("@state",SqlDbType.Char,2,"state");

updateCmd.Parameters.Add(StatePar);

SqlParameter CountryPar=new SqlParameter("@country",SqlDbType.VarChar,30,"country");

updateCmd.Parameters.Add(CountryPar);

SqlParameter PubIDPar=new SqlParameter("@pub_id",SqlDbType.Char,4,"pub_id");

PubIDPar.SourceVersion=DataRowVersion.Original;

updateCmd.Parameters.Add(PubIDPar);



sqlAdatper.UpdateCommand=updateCmd;



DataTable table=ds.Tables["publishers"];

table.PrimaryKey=new DataColumn[]

{

table.Columns["pub_id"]

};

DataRow row=table.Rows.Find(((TextBox)(e.Item.Cells[2].Controls[0])).Text);

row["pub_name"]=((TextBox)(e.Item.Cells[3].Controls[0])).Text;

row["city"]=((TextBox)(e.Item.Cells[4].Controls[0])).Text;

row["state"]=((TextBox)(e.Item.Cells[5].Controls[0])).Text;

row["country"]=((TextBox)(e.Item.Cells[6].Controls[0])).Text;



con.Open();

sqlAdatper.Update(table);

con.Close();



this.DataGrid1.EditItemIndex=-1;

this.BindGrid();

}



/// <summary>

/// 点击删除时触发该事件

/// </summary>

/// <param name="source"></param>

/// <param name="e"></param>

private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)

{

SqlConnection con=new SqlConnection("server=accp-lzh;uid=sa;pwd=sasa;database=pubs");

SqlComman

上一页  [1] [2] [3] [4] [5] [6] [7] 下一页

在google里搜索更多(ASP.NET)修改和删除DataGrid行——数据库访问

	Web www.51ec.org

上一篇信息学院： .Net的Outofmemory异常及大内存使用

下一篇信息学院： ASP.NET中使用Server.Transfer()方法在页间传值