我的datagrid设置了删除项在左边
代码写在Private Sub DataGrid1_DeleteCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.DeleteCommand
myconnection = New SqlConnection,可是运行出错,帮我看看错在哪里
错误:索引超出范围。必须为非负值并小于集合大小。参数名: index myconnection = New SqlConnection
myconnection.ConnectionString = cn
Dim del1 As String
Dim delcmd As SqlCommand
del1 = "delete from rms where ItemNo=" & DataGrid1.DataKeys(e.Item.ItemIndex)
delcmd = New SqlCommand(del1, myconnection)
myconnection.Open()
delcmd.ExecuteNonQuery()
myconnection.Close()
代码写在Private Sub DataGrid1_DeleteCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.DeleteCommand
myconnection = New SqlConnection,可是运行出错,帮我看看错在哪里
错误:索引超出范围。必须为非负值并小于集合大小。参数名: index myconnection = New SqlConnection
myconnection.ConnectionString = cn
Dim del1 As String
Dim delcmd As SqlCommand
del1 = "delete from rms where ItemNo=" & DataGrid1.DataKeys(e.Item.ItemIndex)
delcmd = New SqlCommand(del1, myconnection)
myconnection.Open()
delcmd.ExecuteNonQuery()
myconnection.Close()
解决方案 »
- ASP.NET的gridview里checkbox实现多行删除,可是gridview里只有一行数据时却删除不了?
- ckfinder的用法,帮忙看看
- 哪一个控件可以图像滚动播出
- 奇怪的问题
- 各位大侠,我用aspxgrid1.5做数据录入方式,想在每行添加一个按钮
- asp的网页,导航栏问题
- 为什么SecurityAction.Demand总之抛出异常?
- 帮我看看哪错了
- ASP.NET应届生到哪个城市好找工作呢,求介绍,路过的都进来吐槽吧
- 关于连续查询十几张表甚至几十张表的问题?
- dropdownlist 像树形菜单那样显示,求助????????????
- 一个菜鸟问题:请问要怎样才能把数据库image类型的图片在image控件中显示出来?
楼主DataKeyField忘设置了
还是不行哦
怎么办呢?
你看下我的代码:
string mainkey=this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString();
SqlConnection con=new SqlConnection("server=.;database=cool;trusted_connection=yes");
con.Open();
SqlCommand cmd=new SqlCommand("delete from student where stunum='"+mainkey+"'",con);
cmd.ExecuteNonQuery();
this.datacon();
那么你只要在原来代码的基础上更改& DataGrid1.DataKeys(e.Item.ItemIndex)
--->e.item.cells[i].text就行了
错误:索引超出范围。必须为非负值并小于集合大小。参数名: index
如果是的话建议你在那个表加个主键,把DataKeyField改成你加的主键就解决了