Hello,
I Am getting an exception as ---
Unable to cast object of type 'System.Web.UI.WebControls.DataControlLinkButton' to type 'System.Web.UI.WebControls.TextBox'.
in the code :
Dim row As GridViewRow = GridView1.Rows(e.RowIndex)
Dim vartcktId As String = CType(row.Cells(0).Controls(0), TextBox).Text
Dim varName As String = CType(row.Cells(1).Controls(0), TextBox).Text
Dim varAge As String = CType(row.Cells(2).Controls(0), TextBox).Text
Dim varSex As String = CType(row.Cells(3).Controls(0), TextBox).Text
Dim varReservedClass As String = CType(row.Cells(4).Controls(0), TextBox).Text
Dim varStatus As String = CType(row.Cells(5).Controls(0), TextBox).Text
Dim varsourceId As String = CType(row.Cells(6).Controls(0), TextBox).Text
Dim vardestinId As String = CType(row.Cells(7).Controls(0), TextBox).Text
Dim vartrainNo As String = CType(row.Cells(8).Controls(0), TextBox).Text
Dim vartcktBookDt As String = CType(row.Cells(9).Controls(0), TextBox).Text
Dim varUserId As String = CType(row.Cells(10).Controls(0), TextBox).Text
Dim varReserveDt As String = CType(row.Cells(11).Controls(0), TextBox).Text
Dim sql As String = "Update Passenger set name='" & varName & "', age='" & varAge & "', sex='" & varSex & "', ReservedClass='" & varReservedClass & "', status='" & varStatus & "'where tcktId='" & vartcktId & "'"
Dim sql1 As String = "Update Passenger2 set sourceId='" & varsourceId & "', destinId='" & vardestinId & "' where tcktId='" & vartcktId & "'"
Dim sql3 As String = "Update Reserves set trainNo='" & vartrainNo & "', tcktBookdate='" & vartcktBookDt & "', userId='" & varUserId & "', ReserveDate='" & varReserveDt & "' where tcktId='" & vartcktId & "'"
Dim st As String = ConfigurationManager.ConnectionStrings("TrainsConnectionString").ConnectionString
Dim con As New SqlConnection(st)
Dim cmd As New SqlCommand(sql, con)
Dim cmd2 As New SqlCommand(sql1, con)
Dim cmd3 As New SqlCommand(sql3, con)
con.Open()
cmd.ExecuteReader()
cmd2.ExecuteReader()
cmd3.ExecuteReader()
con.Close()
GridView1.EditIndex = -1
please help me !!