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

Explain ado.net features?

0 Answers  


What is difference between ado.net and asp net?

0 Answers  


When multiple users attempt to modify data at the same time Ex user 1 is updating record at same time user2 deleted record sucessfully.now user1 has press update button . how to handle concurrency

4 Answers   Digital Group,


What is data reader in ado.net?

0 Answers  


What is Data Provider?

0 Answers  


What are the different row versions available?

3 Answers  


What are the various methods provided by the DataSet object to generate XML?

0 Answers  


Which namespaces are used for data access?

0 Answers   SwanSoft Technologies,


What are the steps in connecting to database ?

2 Answers   Microsoft,


can we execute trigger normally at the desired time?

3 Answers   Microsoft,


What connected data?

0 Answers  


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

0 Answers  


Categories