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 is ado recordset?

918

---

What is openrowset?

916

---

Why is stored procedure used in ado.net?

1028

---

Explain the difference in an abstract class and an interface?

870

---

How to work with disconnected data - the dataset and sqldataadapter?

931

---

What is the executescalar method?

1014

---

What is the difference between Optimistic and Pessimistic locking?

923

---

Which is the best method to get two values from the database?

914

---

What is ole used for?

887

---

How to check if a datareader is closed or opened? IsClosed()

966

---

What is datasource in ado.net?

1016

---

What is dataset and datatable in ado.net?

922

---

How to creating a SqlCommand Object?

1068

---

Define different execute methods of ADO.NET command object ?

1000

---

How to find the given query is optimised one or not?

915

---