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();

What is ole2 format?

966

---

What is ado connection?

1010

---

What are the rules to implement connection pooling?

1121

---

Is bulk insert faster than insert?

966

---

What is ado.net architecture?

972

---

What is the purpose of using adodb?

1013

---

What are the steps to connect to a database?

1071

---

What is the advantage of ado.net?

1060

---

Which method is used by command class to execute SQL statements that return single value?

1096

---

What is the DataTableCollection?

1103

---

Difference between sqlcommand and sqlcommandbuilder?

1191

---

What are the difference between readonly vs. Const?

1060

---

Command objects uses, purposes and their methods.

1025

---

What is different between sqlcommand object and command behavior object?

1128

---

Explain all the classes those are used for database connections between sql server and asp.net?

1062

---