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 pre-requisites for connection pooling?

989

---

What is a datareader object?

1081

---

How can we add/remove row's in "datatable" object of "dataset"?

1001

---

What are typed and untyped dataset?

1089

---

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

1024

---

Explain how to bind the controls(best practice) comboboxes to the data in the dataset?

1000

---

What are the differences between OLEDB and SQLClient Providers?

1133

---

Do we use stored procedure in ADO.Net?

979

---

What is maximum pool size in ado.net connection string?

957

---

What do you know about ado.net's objects?

976

---

What is microsoft ole db provider for sql server?

907

---

What is sqldatareader in ado.net?

899

---

What is ado oledb and odbc?

920

---

What is oledb driver?

915

---

What is a control toolbox?

947

---