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 portable executable?

1246

---

How to connect crystal report in vb.net ?

982

---

Explain about Visual basic.NET culture?

1040

---

what is interface and when it is used?

2321

---

What is enumerator?

1050

---

Name some of the features present in vb 2005?

1002

---

Explain convert.tostrin?

1093

---

Explain how to store decimal data in .net?

1218

---

What are the technology areas that microsoft.net contains?

1059

---

What is the maximum size of the textbox?

1031

---

How do you use two datareaders at the same time in a vb.net windows application ?

1111

---

Explain jagged array in vb.net?

1042

---

Explain the use of new keyword?

979

---

What keyword is used to accept a variable number of parameter in a method?

1054

---

Explain about visual basic?

1033

---