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

The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx

1967

---

How can we load multiple tables in to dataset?

1030

---

What are all components of ADO.Net data provider?

1004

---

Define atomicity?

973

---

What is ado.net architecture?

878

---

What do you mean by performing asynchronous operation using command object?

967

---

What are the data providers used in ado.net

969

---

What is difference between entity framework and ado.net?

881

---

Explain how to create dynamic gridview?

919

---

What is the use of data grid?

903

---

Can you explain how to enable and disable connection pooling?

920

---

What are datareaders?

917

---

What are the several execute methods of ado.net?

867

---

What are the different ado.net namespaces are available in .net?

942

---

How to aggregating data across related tables?

974

---