| Other ADO.NET Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is connection pooling ? | Vertex | 3 |
| What are the different namespaces used in the project to
connect the database? | | 2 |
| When we are running the Application, if any errors occur in
the Stored Procedure then how will the server identify the
errors? | HCL | 4 |
| How do you handle data concurrency in .NET ? | | 6 |
| can we execute trigger normally at the desired time? | Microsoft | 2 |
| How do u implement locking concept for dataset? | ABC | 2 |
| 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? | | 5 |
| ADO and ADO.NET differences ? | Microsoft | 2 |
| How to you declare connection strings and how to you make
use of web.config ? | MMTS | 2 |
| What we do with the object of ado.net dataset after using
it?Can we dispose it or can we set it nothing?Is it must or
not? | SVI | 2 |
| How do you filter the data in datagrid? | Choice-Solutions | 1 |
| what is typed and untyped dataset | | 1 |
| What providers does ado.net uses internally ? | Digital-GlobalSoft | 1 |
| what is execute scalar? | Protech | 6 |
| what is Execute NOn Query? | Protech | 9 |
| If i am expecting a single result from sqlserverdatabase
then what command should i follow ?sqlcommand.executereader
(commandbehaviour.singleresult)or sqlcommand.executescalar() | | 4 |
| Can you edit data in the Repeater control? | | 7 |
| How to get oledb connection? | | 3 |
| Difference between DataReader and DataAdapter / DataSet and
DataAdapter? | TCS | 2 |
| What are the three Ado objects? | Microsoft | 5 |
| |
| For more ADO.NET Interview Questions Click Here |