About ado.net components/objects. Usage of data adapters and
tell the steps to retrieve data ?
Answer Posted / 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 View All Answers
Give an example of a .net application which connects to microsoft access database using ado.net classes.
What is bubbled event can you please explain?
How to load multiple tables into a dataset?
What is difference between ado and other data object?
How many major types of connection objects in ADO.NET?
How to pass values into a datatable?
Explain how to create dynamic gridview?
Explain executenonquery?
What is data relation?
What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?
What is ado recordset?
What is ambient transaction?
Why do we use sqldataadapter?
What are the different execute methods of Ado.Net?
Define different execute methods of ADO.NET command object ?