About ado.net components/objects. Usage of data adapters and
tell the steps to retrieve data ?



About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data ?..

Answer / kalirajan

ADO.NET Obj:

SqlConnection
SQlcommand
SqlDataReader
SqlDataAdapter
Dataset


Retrieving Data:

SqlConnection con = new SqlConnection("");
con.Open();
SqlCommand cmd = new SqlCommand("select * from Tbl", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More ADO.NET Interview Questions

How do we invoke queries from the application ?

2 Answers   ICICI, Microsoft,


what is a dataset?

9 Answers   Choice Solutions,


What is acid in ado.net?

0 Answers  


What are dataproviders?

0 Answers  


Explain the two fundamental objects in ado.net?

0 Answers  






What is isolation?

0 Answers  


What are the different execute methods of Ado.Net?

0 Answers  


Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

0 Answers  


types of Store procedure in Sqlserver2000?

4 Answers  


What is adodb dll?

0 Answers  


What is the use of command objects?

2 Answers  


Explain the difference in an abstract class and an interface?

0 Answers  


Categories