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 |
How do we invoke queries from the application ?
What is difference between executenonquery and executequery?
What are the two fundamental objects in ADO.NET?
What is disconnected data?
Which method do you invoke on the DataAdapter control to load your generated dataset with data?
What is a datagrid?
How to Read, Add, Update and Delete record in Entity Framework ?
What is the key feature of ADO.NET compared to ADO ?
What is Dataset Object?
Explain why edit is not possible in repeater?
What is difference between dataset and datatable?
Explain how can we load multiple tables in to dataset?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)