Which method do you invoke on the DataAdapter control to load your generated dataset with data?
5 17342If i am expecting a single result from sqlserverdatabase then what command should i follow ?sqlcommand.executereader (commandbehaviour.singleresult)or sqlcommand.executescalar()
4 8151
What is the return type of executescalar?
What is disconnected data?
What is the hierarchy of data in databases?
Which ado.net object is very fast in getting data from the database?
What is the use of Dataview?
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?
What provider ado.net use by default? Explain the role of data provider in ado.net?
What is ado oledb and odbc?
Define connection string?
Does sqlclient and oledb class share the same functionality?
What do you know about ado.net's objects?
Explain the basic use of "dataview" and explain its methods.
What is difference between ado and other data object?
How to pass values into a datatable?
What is microsoft ole db provider for sql server?