Answer Posted / naresh

Private Sub btnSave_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
btnSave.Click
connection = New SqlConnection("Integrated
Security=sspi; database=naresh; data source=TECH-FATIMA1")
Try
connection.Open()
command = New SqlCommand("spEmployee_Insert")
command.Connection = connection
command.CommandType =
CommandType.StoredProcedure
command.Parameters.AddWithValue("@Name",
txtName.Text)
command.Parameters.AddWithValue("@Dept",
txtDept.Text)
command.Parameters.AddWithValue("@Address",
txtAddress.Text)
Dim result As Integer
result = command.ExecuteNonQuery()
If result > 0 Then
MessageBox.Show("Sucessfully Stored In
Database")
End If
Catch ex As Exception
MessageBox.Show("DataBase Connection Problem")
Finally
connection.Close()

End Try
End Sub

What are the benefits of using ado.net?

1006

---

Explain ODP.net

1008

---

What does sqldatareader return?

965

---

What is the difference between data grid and data repeater?

1079

---

how can implement dropdownlist in particular of dataset when try to update?

2780

---

What is dataset object? Explain the various objects in dataset.

1052

---

What is data access pattern?

947

---

What is the difference between dataset and datatable?

1012

---

What is difference between datareader and dataadapter?

1052

---

If we are not returning any records from the database, which method is to be used?

1331

---

Can we connect two dataadapters to same data source using single connection at same time?

989

---

Give an example of a .net application which connects to microsoft access database using ado.net classes.

1158

---

What are the classes in System.Data.Common Namespace?

1151

---

What is a sqldataadapter?

998

---

Which method in OLEDBAdapter is used to populate dataset with records?

1028

---