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 |
What we do with the object of ado.net dataset after using it?
Explain the difference between ado and ado.net?
WHAT Are the major major compnents of a data provider in ADO.net.
What is a dynaset in access?
What is aggregate root?
Explain how can we load multiple tables in to dataset?
Explain the difference between sqlcommand object and command behavior object?
How to aggregating data across related tables?
Which method is used by command class to execute SQL statements that return single value?
What are major difference between classic ADO and ADO.NET?
Explain the ADO . Net Architecture ( .Net Data Provider) ?
How to check if the Dataset has records ?
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)