ADO.NET Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

ADO.NET Interview Questions

Questions Answers Views Company eMail

How can we add/remove row's in "datatable" object of "dataset"?

971

What is serialization and de-serialization in .net? How can we serialize the dataset object?

908

Define table relations?

923

Describe the command object and its method.

964

How to read data with the sqldatareader ?

925

What is aggregating data ?

912

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

942

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

1057

What are the advantages using ado.net?

984

What are the drawbacks of using ado.net?

920

Explain ado.net features?

990

What are the benefits of using ado.net?

950

If a table contains 20000 records. In a page at each time 100 records to be displayed.

843

Can datareader hold data from multiple tables?

1117

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

933

Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

What is the difference between Datareader and Dataset?

1029

What are the usages of the command object in ado.net?

969

How we can provide data to ado.net?

980

How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?

926

How to creating a SqlCommand Object?

1072

What is openrowset?

923

What is oledb driver?

885

What are good ado.net object to replace to ado recordset object.

1033

Explain the different row versions available in table?

977

What is the use of SqlCommandBuilder?

1150

Which method in OLEDBAdapter is used to populate dataset with records?

962

What is linq and entity framework?

941

can we create synonymn in ms access,sql server,my sql if so explain me with example

2030

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?

969

What is commandbuilder in ado.net?

956

For More Un-Answered { ADO.NET } Questions Click Here