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.

Then I display my Grid View with Taken Date and Status where Student ID = LBStudent ID. Query String("subjectcode") Dim str Section As String = Request.

Text Update Record(Taken Date, Status) GV_Student Record. Data Bind() End Sub End Class Please note that the tablename comes from LBSubject Code LBSection that is brought over from the previous page. Add(New Sql Parameter("@Subject Code", LBSubject Code. Query String("student ID") Dim str Subject Code As String = Request.

You have mentioned that you have done fecth data through select query and bind grid.

Command Text = "UPDATE " & str Table Name & " SET e Date='" & e Date & "', e Status='" & e Status & "' command. gurubhullar Hi, Data Set/Data Table in which you have get the data from database.

Execute Reader return r Catch ex As Exception Msg Box(ex. Ill post it here so that you guys could see whether i've done it the right way, or i am just lost (which i feel i am). This part if for the method suggested by shailesh soni. 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.

But if tried some of the suggestion and codes given.

Data Bind() End Sub Protected Sub GV_Student Record_Row Canceling Edit(By Val sender As Object, By Val e As System. Net way - If using Bound Field Columns Adding Rows in Grid View with Edit, Update and Delete Functionality - If using Template Field Columns PS: The article above uses C#.

I have loads of codes here, because ive tried every way possible. here's a step by step example that you can refer: Grid View Insert, Edit, Update and Delete – The Ado.

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.

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.