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
Can we load multiple tables in a dataset?
What is a control toolbox?
What is ole in excel?
What is the difference between DataReader and DataSet in ADO.NET?
How is entity framework different from ado.net?
Which is the feature of ado.net?
What is the difference between the clone() and copy() methods of the dataset class?
How to read data with the sqldatareader ?
What do you mean by performing asynchronous operation using command object?
What is an ADO.Net?
How to identify the controls which can be used for binding data?
How can I retrieve two tables of data at a time by using data reader?
Name which operations can you not perform on an ado.net dataset?
What are the important features of ado.net 2.0?
What is shadow copy?