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
List the 4 common ado.net namespaces?
Which database is the ado.net?
What is ado recordset?
Which is the feature of ado.net?
How do you find the count of records in a dataset?
What is a control toolbox?
Define executenonquery?
What is ado.net components?
What is difference between executequery and executeupdate?
How to create dynamic gridview?
Which object is used to add relationship between two Datatables?
What is difference in record set and dataset?
How can we check that some changes have been made to dataset since it was loaded?
What Is Difference Between Ado And Ado.net?
How to add a check box or a dropdown list to a column in a datagrid?