我把LinkButton连接到MyDataGrid_Delete这个函数
public void MyDataGrid_Delete(Object sender, DataGridCommandEventArgs e)
{
OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+ Server.MapPath("new.mdb"));
String deleteCmd = "DELETE from news where id = @Id";
OleDbCommand myCommand = new OleDbCommand(deleteCmd, myConnection);
myCommand.Parameters.Add(new OleDbParameter("@Id", OleDbType.Char, 11));
myCommand.Parameters["@Id"].Value = MyList.DataKeys[(int)e.Item.ItemIndex]; myCommand.Connection.Open(); try
{
myCommand.ExecuteNonQuery();
}
catch (OleDbException)
{
}
可是就是实现不了最后的删除!请各位大哥指导!
myCommand.Connection.Close();
DataBind();
}
public void MyDataGrid_Delete(Object sender, DataGridCommandEventArgs e)
{
OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+ Server.MapPath("new.mdb"));
String deleteCmd = "DELETE from news where id = @Id";
OleDbCommand myCommand = new OleDbCommand(deleteCmd, myConnection);
myCommand.Parameters.Add(new OleDbParameter("@Id", OleDbType.Char, 11));
myCommand.Parameters["@Id"].Value = MyList.DataKeys[(int)e.Item.ItemIndex]; myCommand.Connection.Open(); try
{
myCommand.ExecuteNonQuery();
}
catch (OleDbException)
{
}
可是就是实现不了最后的删除!请各位大哥指导!
myCommand.Connection.Close();
DataBind();
}
解决方案 »
- 求大侠帮忙,在线等jQuery传值问题
- DataGrid,或者Repeater等如何绑定动态列?动态列如何绑定数据?
- ASP.net中用数据库连接方式向Excel表格中插入数据遇到的问题
- 给DropDownList能直接add数组吗??
- 求一个验证用户名和密码的政策表达式
- 在线播放/在线广播
- 通过强类型DataSet更新数据的问题。
- 求助:同一个局域其网里的他机器不能访问我机器上的web service,而我在自己机器上访问却没有问题,why???
- 求.net(C#)数据访问底层类,可以相互交换!
- 请问我该怎样实现一个用户账号只能让一个用户在线?
- 70高分求救一个ASP。NET问题```求救`````求高手解答```在线等后。
- 请教日期格式转换函数!
public void MyDataGrid_Delete(Object sender, DataGridCommandEventArgs e)
{
OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+ Server.MapPath("new.mdb"));
String deleteCmd = "DELETE from news where id = ?";
OleDbCommand myCommand = new OleDbCommand(deleteCmd, myConnection);
myCommand.Parameters.Add(new OleDbParameter("Id", OleDbType.Char, 11));
myCommand.Parameters["Id"].Value = MyList.DataKeys[(int)e.Item.ItemIndex]; myCommand.Connection.Open(); try
{
myCommand.ExecuteNonQuery();
}
catch (OleDbException)
{
}