using System.Data.SqlClient
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!Page.IsPostBack )
{
bindgrid();
}
}
public void bindgrid()
{
SqlConnection myConnection =new SqlConnection ("server=wsg;database=jsj;uid=sa;password=;;");
SqlDataAdapter orderdet=new SqlDataAdapter ("select * from jsj",myConnection);
DataSet ds=new DataSet ();
orderdet.Fill(ds,"jsj");
DataGrid1.DataSource=ds;
DataGrid1.DataBind ();
}
private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string name; TableCell id=e.Item.Cells[1]; name=id.Text; SqlConnection myConnection=new SqlConnection("server=wsg;database=jsj;uid=sa;password=;"); SqlCommand deleteCmd=new SqlCommand("deleter",myConnection); deleteCmd.CommandType=CommandType.StoredProcedure; deleteCmd.Parameters.Add(new SqlParameter("@IID",SqlDbType.NChar,20)); deleteCmd.Parameters["@IID"].Value=DataGrid1.DataKeys[(int)e.Item.ItemIndex]; deleteCmd.Connection.Open ();
deleteCmd.ExecuteNonQuery(); lblmessage.Visible=true; lblmessage.Text="The order with invoice number"+name+"has been successfully deleted"; bindgrid(); }
窗体DataGride的DataKeyField属性设置为数据库主健name!为什么不能删除数据库内的内容?高手帮忙解决!谢谢!快速结帖!
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!Page.IsPostBack )
{
bindgrid();
}
}
public void bindgrid()
{
SqlConnection myConnection =new SqlConnection ("server=wsg;database=jsj;uid=sa;password=;;");
SqlDataAdapter orderdet=new SqlDataAdapter ("select * from jsj",myConnection);
DataSet ds=new DataSet ();
orderdet.Fill(ds,"jsj");
DataGrid1.DataSource=ds;
DataGrid1.DataBind ();
}
private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string name; TableCell id=e.Item.Cells[1]; name=id.Text; SqlConnection myConnection=new SqlConnection("server=wsg;database=jsj;uid=sa;password=;"); SqlCommand deleteCmd=new SqlCommand("deleter",myConnection); deleteCmd.CommandType=CommandType.StoredProcedure; deleteCmd.Parameters.Add(new SqlParameter("@IID",SqlDbType.NChar,20)); deleteCmd.Parameters["@IID"].Value=DataGrid1.DataKeys[(int)e.Item.ItemIndex]; deleteCmd.Connection.Open ();
deleteCmd.ExecuteNonQuery(); lblmessage.Visible=true; lblmessage.Text="The order with invoice number"+name+"has been successfully deleted"; bindgrid(); }
窗体DataGride的DataKeyField属性设置为数据库主健name!为什么不能删除数据库内的内容?高手帮忙解决!谢谢!快速结帖!
解决方案 »
- 求教DATASET地址内存分配
- 求一条Sql语句?
- jmail 的 send(server)如何设置
- ASP.NET交流
- 非高手勿请:奇怪的未将对象引用设置到对象的实例
- 学好多少种语言才能做网站开发
- 请问这句话中的Response.Write("<script>opener.parent.parent.header.location.reload();</script>");header代表什么?
- 请问谁能帮我 <<<<<<<comboBox 怎么根据指定的数据选定他 >>>>>>>>不帮也来顶!有分!!
- 怎么在asp.net MVC4写的项目下对Web.config中的数据库连接串进行加密?
- 又是DATAGRID的问题,各位大侠帮看看了。
- Nhibernate 的hql查询问题,hql好象没起到作用呀....
- webapplication是不是不能穿过防火墙和局域网?
1.把private void DataGrid1_DeleteCommand这个程序块剪切掉,然后重新在设计器中生成这个事件,然后把代码粘贴回来。
2.设置断点,然后在按f11键一步一步的跟踪。