Answer / sundara

four data table type#
1. Perment data table
2. temp table only for the session
3. temp table will destroy wilie the connection close
4. table variable

Answer / sreedevi

2 data tables
perment table& temp table

Answer / sudhakar basore

four data table type#
1. Perment data table
2. temp table only for the session
3. temp table will destroy wilie the connection close
4. table variable

Answer / mohit

2 Tables

1). Temporary table

2). Global table

Which provider is used to connect ms access, oracle, etc…?

0 Answers  

---

What providers does ado.net uses internally ?

3 Answers   Digital GlobalSoft,

---

What is a datatable?

8 Answers   State Bank Of India SBI,

---

If a table contains 20000 records . In a page at each time 100 records to be displayed. What are the steps u will take to improve performance? will you use dataset or datareader?

7 Answers  

---

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?

0 Answers  

---

---

What is the difference between statement and preparedstatement interface?

0 Answers  

---

Explain the different row versions available in table?

0 Answers  

---

What is connection pooling and what is the maximum pool size in ado.net connection string?

0 Answers  

---

What are the Different layers in ADO.Net?

10 Answers   eXensys,

---

Execute nonquery returns no. of afected rows.So if my stored procedure hav lot of select stmnt, delete stmnt, insert stmnt..then what does execute nonquery returns in this case?

6 Answers   Wipro,

---

OleDbDataAdapter ole=new OleDbDataAdapter(new OleDbCommand ("select * from login",oleDbConnection1)); OleDbCommandBuilder cmd=new OleDbCommandBuilder(ole); ole.Fill(dataSet11,"login"); DataRow drow=dataSet11.Tables ["login"].NewRow(); drow[0]=textBox1.Text; drow[1]=textBox2.Text; drow[2]=textBox3.Text; dataSet11.Tables["login"].Rows.Add (drow); ole.UpdateCommand=cmd.GetUpdateCommand(); ole.Update(dataSet11,"login"); MessageBox.Show("one row added"); this gives exception.how to solve it

1 Answers   Nimaya,

---

What is ado object model?

0 Answers  

---