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?
553If 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?
614
How many major types of connection objects in ADO.NET?
How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
What are the ado.net objects?
Can we do database operations without using any of the ado.net objects?
How to add an aggregate column?
What is openrowset?
Which is faster entity framework or ado.net?
What are the steps you will take to improve performance?
What is row state?
Explain the difference between data reader and data set?
What is difference between executequery and executeupdate?
In how many ways we can retrieve table records count? How to find the count of records in a dataset?
What are the advantage of ado.net?
What do you mean by ‘batch updates’?
What are two important objects of ADO.Net?