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()

What is the significance of delegates?

955

---

What are the different types of Lock available in Visual Basic?

1089

---

What is the importance of a Button control?

1298

---

What is globalization?

971

---

What are the differences between server-side and client-side code?

1023

---

What is enumerator?

996

---

what is the need for dynamic controls in vb.net? i would like to know for what purpose should we create the controls dynamically? please give the answer in simple words.

2374

---

What is a stream in vb.net?

984

---

What are jagged arrarys ?

969

---

What is the difference between manifest and metadata?

1052

---

What is non_deterministic finalization?

1076

---

What is branching logic control in VB.NET?

972

---

What is normal jit?

1042

---

List the different types of assembly?

930

---

What is static member?

1002

---