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 the default provider in ado.net?
What is a datagrid?
When we are running the Application, if any errors occur in the Stored Procedure then how will the server identify the errors?
What is bubbled event?
Explain the basic use of "dataview" and explain its methods.
Explain how to create dynamic gridview?
What is sqldatasource?
What is the difference between oledbreader and datasetwhile connecting?
Give an example that shows how to execute a stored procedure in ado.net?
What is the role of clr?
What is dataset object? Explain the various objects in dataset.
What happens when u try to update data in a dataset in .NET while the record is already deleted in SQL SERVER as backend?
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)