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?

1089

---

What is the executescalar method?

1180

---

Explain the role of data provider in ado.net?

1056

---

What is isolation?

1079

---

What are the different row versions available in table?

1036

---

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

1111

---

How do you connect to sql server database without using sqlclient?

1178

---

What are the steps to connect to a database?

1074

---

What is connection string?

1058

---

How can I retrieve two tables of data at a time by using data reader?

1098

---

Does sqlclient and oledb class share the same functionality?

984

---

What is different between sqlcommand object and command behavior object?

1137

---

Data reader read and forward only, how is it possible to get 2 tables of data at a time?

972

---

How to find the given query is optimised one or not?

1023

---

What is the role of data provider in ado.net?

1053

---