Beginner: Insert, Update, Delete & Search records from/to sql database
Expand Post »
Hi Everyone,
First of all, thanx Mojio for providing me the right code information on connecting sql server database.
As I'm a beginner in ASP.NET, using vb as language. I have created few text boxes on the form as an input to the application. I hav managed to insert the records to the sql, but not managed to search & update the records from sql.
My Code's on Insert Button: Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim strConn As String = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\staff.mdf;Integrated Security=True;User Instance=True" Dim cmd As New SqlCommand("INSERT INTO Staff (NRIC, Name, Address, TelNo)VALUES('" & txtIC.Text & "','" & txtName.Text & "','" & txtAddress.Text & "','" & txtTelNo.Text & "')",New SqlConnection(strConn))
cmd.Connection.Open()
cmd.ExecuteNonQuery()
cmd.Connection.Close() End Sub
My Query:
I'm trying to update the records thru the textboxes created. The scenario is, the user will key in his student ID in the enter student ID textbox and click on the search button. Then All the details about him such as name, telNO will be displayed accordingly in other textboxes created.How can I retrieve the data from sql back into the textboxes created and from there i edit and update the changes back to sql. Please advise 10q.
here is one way to get the info and display it on the screen. See if this works, if it does, try to "reverse" it to get it to update. Let me know if you need help.
Thanx 4 ur info campkev. I hav tried the codes, it's still showing the msg"Invalid attempt to MetaData when reader is closed" under the InvalidOperationException was unhandled by user codedialog box. It was pointing the
txtName.Text = dr("Name")
txtAddress.Text = dr("Address")
I hav tried to write the above code like below after that:
cmd.Connection.Open() n
dr = cmd.ExecuteReader()
txtName.Text = dr("Name")
txtAddress.Text = dr("Address")
cmd.Connection.Close()
This time it's showing the msg"Invalid attempt to read when no data is present" under the InvalidOperationException was unhandled by user codedialog box by pointing the
txtName.Text = dr("Name")
txtAddress.Text = dr("Address")
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
This thread is currently closed and is not accepting any new replies.
Previous Thread in ASP.NET Forum Timeline:drop down list
Unsolved 
