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

Some important instruction regarding ADO.NET connection string ?

942

---

What is row state?

934

---

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

957

---

Where is adodb dll located?

935

---

How to enable and disable connection pooling?

1005

---

What is ado circle?

1095

---

What is linq and entity framework?

954

---

What is ado net stands for?

918

---

What is the provider being used to access oracle database?

956

---

What are the core objects of ADO.NET?

1001

---

Do you use stored procedure in ado.net?

1007

---

What is the difference between SqlCommand and SqlCommandBuilder?

1025

---

Compare Data Reader & Dataset in ado.net?

954

---

What is dbcontext and dbset in entity framework?

893

---

How would you connect to a database by using .NET?

905

---