Answer Posted / kalirajan

// Declare Namespace as ur Lang...
In c#

Using System.Data.SqlClient;

//connection

SqlConnection con = new
SqlConnection("server=localhost;database=Grid_Db;uid=sa;pwd=;");

con.Open();

SqlCommand cmd = new SqlCommand("select * from Gtid_Tbl",con);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

GridView1.DataSource = ds;
GridView1.DataBind();

What is an orm, and why would you use one instead of plain old ado.net?

995

---

What is microsoft ado.net?

1065

---

What is ole word?

891

---

What is difference between ado and other data object?

860

---

How do you update a dataset in ado.net and how do you update database through dataset?

871

---

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

1013

---

What are the Features and disadvantages of dataset

1031

---

What is difference between sqldatareader and sqldataadapter?

891

---

Which architecture does Datasets follow?

982

---

What is oledb connection?

930

---

What are all components of ADO.Net data provider?

1002

---

Explain what are acid properties?

917

---

If a table contains 20000 records. In a page at each time 100 records to be displayed.

838

---

What is the purpose of using adodb?

898

---

What is row state?

922

---