update query not working when i attach the content of text box using data reader on page load

Vote count:

0

Code works fine when i remove the page load content. this is a form which will allow user to edit the data already present in database. i just want to let a user edit a form which he have already submitted. This is the code:

Dim con As New SqlConnection("Data Source=ENCODER-PC\SQLEXPRESS;Integrated Security=True")
Dim cmd, com As New SqlCommand
Dim dr As SqlDataReader
Dim n, d, a As Integer
Dim returnValue As Object
Dim str As String


Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load


    str = "select * from School where RollNo=11"
    com = New SqlCommand(str, con)
    dr = com.ExecuteReader()
    con.Open()        
    If (dr.Read()) Then

        Enroll.Text = dr("RollNo").ToString()
        Name.Text = dr("Name").ToString()
        Class.Text = dr("Class").ToString()
    End If
    con.Close()
    dr.Close()

End Sub



Protected Sub Next_Click(sender As Object, e As EventArgs) Handles [Next].Click
    Try
        cmd.CommandText = "Update School SET RollNo='" & Enroll.Text & "', Name='" & Name.Text & "', Class='" & Class.Text & "'  where RollNo=11 "


        cmd.Connection = con


        con.Open()

        MsgBox("Connection is Open ! ")
        n = cmd.ExecuteNonQuery
        If n > 0 Then
            MsgBox("data inserted successfully")
        Else
            MsgBox("data insertion failed")
        End If
    Catch ex As Exception
        MsgBox(ex.ToString())
    Finally
        con.Close()
    End Try
End Sub

asked 1 min ago

Abuzer BCA

3

update query not working when i attach the content of text box using data reader on page load