Private Sub DataGrid2_CancelCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid2.CancelCommand
Me.DataGrid2.EditItemIndex = -1
setBind()
End Sub Private Sub DataGrid2_UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid2.UpdateCommand
Dim conn As New SqlConnection(System.Configuration.ConfigurationSettings.AppSettings("gonglu_DSN"))
Dim sql = "Update tblLogin set Login_name=@Login_name,Login_password=@Login_password,user_name=@user_name,user_email=@user_email where user_id=@id"
Dim comm As New SqlCommand(sql, conn) Dim parm1 As New SqlParameter("@Login_name", SqlDbType.NVarChar)
Dim strLoginname As String = CType(e.Item.FindControl("Login_name"), TextBox).Text
parm1.Value = strLoginname
Dim parm2 As New SqlParameter("@login_password", SqlDbType.NVarChar)
Dim strLoginpassword As String = CType(e.Item.FindControl("login_password"), TextBox).Text
parm2.Value = strLoginpassword
Dim parm3 As New SqlParameter("@user_name", SqlDbType.NVarChar)
Dim strUsername As String = CType(e.Item.FindControl("user_name"), TextBox).Text
parm3.Value = strUsername
Dim parm4 As New SqlParameter("@user_email", SqlDbType.NVarChar)
Dim strUseremail As String = CType(e.Item.FindControl("user_email"), TextBox).Text
parm4.Value = strUseremail
Dim parm5 As New SqlParameter("@id", SqlDbType.Int)
parm5.Value = Me.DataGrid2.DataKeys(e.Item.ItemIndex) comm.Parameters.Add(parm1)
comm.Parameters.Add(parm2)
comm.Parameters.Add(parm3)
comm.Parameters.Add(parm4)
comm.Parameters.Add(parm5) Try
conn.Open()
comm.ExecuteNonQuery()
conn.Close()
Me.DataGrid2.EditItemIndex = -1
setBind()
Catch ex As Exception
If conn.State = ConnectionState.Open Then
conn.Close()
End If
End Try End Sub错误信息:未将对象引用设置到对象的实例。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.NullReferenceException: 未将对象引用设置到对象的实例。源错误:
行 200:
行 201: Dim parm1 As New SqlParameter("@Login_name", SqlDbType.NVarChar)
行 202: Dim strLoginname As String = CType(e.Item.FindControl("Login_name"), TextBox).Text '错误行
行 203: parm1.Value = strLoginname
行 204: Dim parm2 As New SqlParameter("@login_password", SqlDbType.NVarChar)
谁能帮我看一下啊,谢谢
Me.DataGrid2.EditItemIndex = -1
setBind()
End Sub Private Sub DataGrid2_UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid2.UpdateCommand
Dim conn As New SqlConnection(System.Configuration.ConfigurationSettings.AppSettings("gonglu_DSN"))
Dim sql = "Update tblLogin set Login_name=@Login_name,Login_password=@Login_password,user_name=@user_name,user_email=@user_email where user_id=@id"
Dim comm As New SqlCommand(sql, conn) Dim parm1 As New SqlParameter("@Login_name", SqlDbType.NVarChar)
Dim strLoginname As String = CType(e.Item.FindControl("Login_name"), TextBox).Text
parm1.Value = strLoginname
Dim parm2 As New SqlParameter("@login_password", SqlDbType.NVarChar)
Dim strLoginpassword As String = CType(e.Item.FindControl("login_password"), TextBox).Text
parm2.Value = strLoginpassword
Dim parm3 As New SqlParameter("@user_name", SqlDbType.NVarChar)
Dim strUsername As String = CType(e.Item.FindControl("user_name"), TextBox).Text
parm3.Value = strUsername
Dim parm4 As New SqlParameter("@user_email", SqlDbType.NVarChar)
Dim strUseremail As String = CType(e.Item.FindControl("user_email"), TextBox).Text
parm4.Value = strUseremail
Dim parm5 As New SqlParameter("@id", SqlDbType.Int)
parm5.Value = Me.DataGrid2.DataKeys(e.Item.ItemIndex) comm.Parameters.Add(parm1)
comm.Parameters.Add(parm2)
comm.Parameters.Add(parm3)
comm.Parameters.Add(parm4)
comm.Parameters.Add(parm5) Try
conn.Open()
comm.ExecuteNonQuery()
conn.Close()
Me.DataGrid2.EditItemIndex = -1
setBind()
Catch ex As Exception
If conn.State = ConnectionState.Open Then
conn.Close()
End If
End Try End Sub错误信息:未将对象引用设置到对象的实例。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.NullReferenceException: 未将对象引用设置到对象的实例。源错误:
行 200:
行 201: Dim parm1 As New SqlParameter("@Login_name", SqlDbType.NVarChar)
行 202: Dim strLoginname As String = CType(e.Item.FindControl("Login_name"), TextBox).Text '错误行
行 203: parm1.Value = strLoginname
行 204: Dim parm2 As New SqlParameter("@login_password", SqlDbType.NVarChar)
谁能帮我看一下啊,谢谢
解决方案 »
- 请教一下
- 风之石框架研究之 function(id, oldval, newval) 有什么用?
- |zyciis| 如何用参数化的方式查询数据库中字段为null的数据(有代码),谢谢
- 在服务器的WINFORM程序里,怎样读取该服务器某个网站的Application对象?WebService是不是可以?
- 给30分,急呀!ExecuteNonQuery: CommandText 属性尚未初始化 给30分,急呀!
- 程序操作excel 有没一个属性标志某行或某单元格为选中状态
- 实现同步接收信息的问题
- 数据库检索
- 企业邮箱问题
- 关闭指定网页怎么做,送分
- 2005.net中的treeview为什么只有TreeView1_SelectedNodeChanged事件
- asp.net中最费解的数据绑定问题,貌似还没看到过满意的答案
------说错了莫怪。