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 + "')", myconnection)
ra=myCommand.ExecuteNonQuery()
MessageBox.Show("New Row Inserted" & ra)
myConnection.Close()

What is redim keyword and its use?

1036

---

How to view an assembly?

965

---

Explain how to store decimal data in .net?

1173

---

What is the purpose of an Assembly?

1076

---

What is DLL HELL in VB.NET

1022

---

What is normal jit?

1049

---

What are jagged arrays ?

1046

---

Explain public assembly?

966

---

Can you please explain the difference between vb and vb.net?

894

---

What are the advantages of vb.net and c#?

1118

---

How can we remove handlers at run time?

1062

---

Explain clr?

1043

---

What is vb.net used for?

940

---

What are the different variables in vb.net?

963

---

Define cls?

1007

---