How to Insert a TextBox value in to Sql database using
VB.Net coding?
Answer Posted / deepmala soni
Dim myConnection As SqlConnection
Dim myCommand As SqlCommand
Dim ra as Integer
'integer holds the number of records inserted
myConnection = New SqlConnection
("server=localhost;uid=sa;pwd=;database=Hospital")
'you need to provide password for sql server
myConnection.Open()
mycommand = New SqlCommand("INSERT INTO Patient
(ID,Name,address,DateofBirth,Gender,Phone,Emergencycontact,D
ateofRegistration) VALUES('" + lblid.Text + "','" +
txtname.Text + "','" + rtxtaddress.Text + "','" +
DateTimePicker1.Text + "','" + cmbgender.Text + "','" +
txtphone.Text + "','" + txtemcon.Text + "','" +
txtdoreg.Text + "')", mycon)ra=myCommand.ExecuteNonQuery()
MessageBox.Show("New Row Inserted" & ra)
myConnection.Close()
| Is This Answer Correct ? | 32 Yes | 23 No |
Post New Answer View All Answers
what is commom language runtime?
difference between checkbox vs radiobutton??
Explain the difference between web.config and machine.config and where it will be ?
Explain the components of common language runtime.
Explain and brief about rapid application development tool?
Explain the difference between .dll extension and .exe extension files?
What is the difference between manifest and metadata?
Explain strong name in .net assembly?
What are the parts of the visual basic control?
Define clr?
Explain the difference between vb 6 and vb.net?
What is intermediate langauge?
What is static member?
Explain the difference between value and reference types?
Explain about the feature anonymous type?