What providers does ado.net uses internally ?
Answers were Sorted based on User's Feedback
Answer / debadutta
ADO.Net uses
1) Oledb
2) ODBC
3) JET Providers
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / vivek
Before ado.net 2.0 they give only interfaces to implemetn
them then every provider started implementing on their own
way so problem araised with these implementation.
From ado.net2.0 it gives abstract classes like DbConnetion
to providers.Then the providers create classes to implement
those abstract classes.
Ex:SqlConnection,OracleConnection.
with thses abstract classes we can connect to any backend.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is Data Provider?
What happens when u try to update data in a dataset in .NET while the record is already deleted in SQL SERVER as backend?
What is the difference between data grid and data repeater?
What is the significance of CommandBehavior.CloseConnection ?
About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data ?
Which is faster entity framework or ado.net?
What is disconnected architecture in ado.net?
What is connection in ado.net?
Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
what is the syntax code to oledb to connect oracle
How To Update A Column In A DataGrid Using C#.NET? I am getting InvalidCastException as (Specified cast is not valid) while updating 2nd column in a datagrid? Id,firstname,lastname are the three columns of my datagrid respectively. I wanted to edit the second column(lastname) and update it. I did the following code in DataGrid's updatecommand(),but failed to update ! Int varid=(int)DataGrid1.DataKeys[e.Item.ItemIndex]; TextBox lnm=(TextBox)e.Item.Cells[2].Controls[0]; string str=lnm.Text ; SqlCommand cmd=new SqlCommand("update customer set lastname='" + str + "' where id=" + varid + "",con); cmd.ExecuteNonQuery(); DataGrid1.EditItemIndex=- 1; DataGrid1.DataBind();
What are all features of ADO.Net?
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)