Answer Posted / srinivas.kinthada

i think it's oledb may b.

in c#.net coding

1)
using oledd provider
1.system.data.oledb;
2.oledbconnection cn=new
oledbconnection("username=<username>;pwd=<password>;server=<servername>");
3.cn.open();

2)
using orcale provider
1.first u can give in u r application reference of
system.data.orcaleclient.dll file trough solutionexplorer of
u r application
(rt click the mouse--->over solutinexplorer--->and click add
reference--->click on project---> and select
system.data.orcaleclient.dll file--->ok )
2.using system.data.orcaleclient;
3.orcaleconnection cn=new
orcaleconnection("username=<username>;pwd=<password>;server=<servername>");
3.cn.open();

Which object of ado contains datarow datacolumn collection?

1012

---

How to load multiple tables into a dataset?

1124

---

What is the use of sqldatareader class?

1053

---

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?

1085

---

What is the use of SqlCommand object?

1289

---

What is maximum pool size in ado.net connection string?

1023

---

What are the advantages using ado.net?

1088

---

What is the difference between data reader and data adapter?

1074

---

What is ado.net architecture?

972

---

Explain which name space is used to get assembly details?

1024

---

What do you know about ado.net's objects?

1074

---

What are the steps you will take to improve performance? Will you use dataset or datareader?

1050

---

What are the data providers used in ado.net

1063

---

What is microsoft ole db provider for sql server?

977

---

What is untyped dataset?

1146

---