Answer Posted / sireesha

C#:
System.Data.SqlClient;
In the method {}...
Step 1: Create a connection:
SqlConnection con = new SqlConnection();
Con.ConnectionString = “DataSource =Server Name;
Initial Catalog = Database Name; Integrated Security=True”;
Step 2: Create a Command:
SqlCommand cmd = new SqlCommangd();
Step 3: Bind the Command to Connection:
cmd.Connection = con;
Step 4: Initialise the Command with SQL Statement to execute
EX:-
String Name = txtName.Text;
decimal Salary = decimal.parse(txtsalary.Text);
cmd.CommandText = "insert into Emp
(EmpName,EmpSalary) Value(' "+name+" ',"+salary")";
Step 5: Open the Connection
con.Open();
Step 6: Execute the Command
Like we have different execute command statements
like ExecuteNonQuery(),ExecuteScalar(),ExecuteReader(). Use
as per the requirement of data.
Step 7: Close the connection
con.Close();

Explain the differences between oledb sql server, oledbdotnet provider?

1014

---

What is a string variable?

917

---

How do I delete a row from a DataTable?

1167

---

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

1051

---

What is the use of SqlCommandBuilder?

1208

---

Describe ado.net object model in detail.

997

---

Which is faster ado.net or linq?

1027

---

Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?

1067

---

Define Execute Reader?

1069

---

Define different execute methods of ADO.NET command object ?

1097

---

What is the difference between the clone() and copy() methods of the dataset class?

1089

---

What are all the different methods under sqlcommand?

986

---

What is the use of Dataview?

1134

---

How to connect and retrieve data from database using dataset

1056

---

What are all the different authentication techniques used to connect to MS SQL Server?

1089

---