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 is connected architecture in ado.net?
Describe the disconnected architecture of ADO.NET’s data access model.
How will you fill the gridview by using datatable object at runtime?
what is different between SqlCommand object and Command Behaviour Object
We all know that Dataset is purely disconnected architechure, but we also know that we can update the changes made to the dataset can be updated in the backend database. when there is no connection how does the update happedn?
6 Answers Accenture, FastStream,
Which is the best institute in navi mumbai to learn DotNet
What is ado.net connection?
What is adodb dll?
Explain the different row versions available in table?
What is difference between executenonquery and executequery?
What are the several execute methods of ado.net?
Explain how do you connect to sql server database without using sqlclient?
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)