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 common language specification?

920

---

Which class allows an element to be accessed using unique key?

909

---

What is redim keyword?

939

---

What is the strong name in .net assembly?

950

---

What is difference between inline and code behind?

974

---

Write a program to find all text files in a logical drive and return the count of the number of files?

2657

---

What is the difference between import system.data.sqlclient and system.data.oledb?

878

---

what is interface and when it is used?

2219

---

What is stack used for in vb. Net?

889

---

What is the feature anonymous type?

864

---

Explain about Visual basic.NET culture?

952

---

What are the difference between dispose(), close(), exit(), end()?

853

---

What is a static variable?

1637

---

What is sealed class?

1067

---

What do you mean by Redim in VB.NET?

1107

---