Rowupdating with

Because from the suggested sites that Vinz gave me, i found that datatable/dataset wasnt in used. Query String("student ID") Dim str Subject Code As String = Request.

Source Error: Dear Shailesh Soni, Do i really need to used those? Text = str Section Dim str Table Name As String = LBSubject Code. Text 'Msg Box(str Table Name) Dim conn String As String = Configuration Manager. Connection String Using my Conn As New Sql Connection(conn String) my Conn.

Data Bind() End Sub Protected Sub GV_Student Record_Row Canceling Edit(By Val sender As Object, By Val e As Grid View Cancel Edit Event Args) GV_Student Record. Data Bind() End Sub Protected Sub GV_Student Record_Row Updating(By Val sender As Object, By Val e As Grid View Update Event Args) Dim Taken Date As String = Direct Cast(GV_Student Record. Query String("subjectcode") Dim str Section As String = Request.

make Get Data() function which will return Sql Data Reader as follow: Protected Function Get Data() As Sql Data Reader Dim str Student ID As String = Request. Text = str Section Dim str Table Name As String = LBSubject Code. Text 'Msg Box(str Table Name) Dim conn String As String = Configuration Manager. Connection String Using my Conn As New Sql Connection(conn String) my Conn.

Page Protected Sub Login Status1_Logged Out(By Val sender As Object, By Val e As System. Open() Dim cmd As New Sql Command(sql Statement, my Conn) cmd.

rowupdating with-18rowupdating with-46rowupdating with-73rowupdating with-29

Row Updating Dim conn String As String = Configuration Manager. Connection String Dim e Date, e Status As String Dim str Table Name As String = LBSubject Code.

Text Dim Status As String = Direct Cast(GV_Student Record. Thank you so much for being interested and helping me out. gurubhullar Hi, By looking into your code, Grid will bind on each postback so your code in Row Editing and Row Deleting will not get effect.

Text This is a class attendance taking system, i want the lecturer to be able to edit student's attendance record in case there was a mistake. Command Text = "Select Taken Date, Status FROM " & str Table Name & " WHERE Student [email protected] ID AND Subject [email protected] Code AND [email protected]" With command.

Please review the stack trace for more information about the error and where it originated in the code. Invalid Operation Exception: Invalid attempt to call Field Count when reader is closed.

Description: An unhandled exception occurred during the execution of the current web request. Command Text = "Select Taken Date, Status FROM " & str Table Name & " WHERE Student [email protected] ID AND Subject [email protected] Code AND [email protected]" With command.

Leave a Reply