Answer Posted / sinthu vijay kumar

hi friends...

we have so many databases for ex oracle,sql
server,sybase,ms Access etc.providers are used to giving
the connecion to the database ,which r different for
different databases.the avilable providers in ado.net are
oracle.net data provider,odbc.net dataprovider etc.
the syntax for provider is:
con=new odbcconnection
("uid=scott,pwd=tiger,database=oracle")
here uid,pwd,database r vary with different databases.

Do we use stored procedure in ADO.Net?

940

---

How to connect and retrieve data from database using dataset

983

---

What are all the different methods under sqlcommand?

920

---

Which database is the ado.net?

914

---

What is data view and variable view?

855

---

What are dataproviders?

902

---

What are ado.net objects?

1009

---

What is commandbuilder in ado.net?

952

---

What is the difference between sqlcommand and sqldataadapter?

947

---

What is meant by executenonquery?

887

---

I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?

967

---

What are the classes in System.Data.Common Namespace?

1086

---

What are the key features of ado.net?

1126

---

What is Serialization in .NET? what are the types of Serialization?

1024

---

What is oledb driver?

882

---