PDA

View Full Version : Ado.Net


  1. Advantage of ADO.Net
  2. How would u connect to database using .NET
  3. Difference between OLEDB Provider and SqlClient
  4. What are relation objects in dataset and how & where to use them
  5. What are the different namespaces used in the project to connect the database
  6. Difference between DataReader and DataAdapter / DataSet and DataAdapter
  7. Which method do you invoke on the DataAdapter control to load your generated dataset
  8. How to find the count of records in a dataset
  9. How to check if a datareader is closed or opened
  10. Explain different methods and Properties of DataReader
  11. What happens when we issue Dataset.ReadXml command
  12. How to get oledb connection
  13. What are the 4 types of classes in ADO.NET
  14. How can you implement sub data grid in a master datagrid
  15. What is method to get XML and schema from Dataset
  16. What are the two fundamental objects in ADO.NET
  17. How to generate XML from a dataset and vice versa
  18. If a dataset contains 100 rows, how to fetch rows between 10 and 20 only
  19. How do you merge two datasets into the third dataset in a simple manner
  20. How do u implement locking concept for dataset
  21. What is the use of parameter object
  22. What's the difference between Dataset.clone and Dataset.copy
  23. Differences between dataset.clone and dataset.copy
  24. What are the differences between RAW, AUTO
  25. What happens when u try to update data in a dataset in .NET
  26. What is ADO .NET and what is difference between ADO and ADO.NET
  27. What we do with the object of ado.net dataset after using it
  28. What are advantages and disadvantages of Microsoft-provided data provider classes
  29. How can implement dropdownlist in particular of dataset when try to update
  30. What?s the role of the DataReader class in ADO.NET connections
  31. How to get the new oledb connection of oracle in database programming
  32. What are the advantages of oledb compared with other classes
  33. What is a dataset
  34. What is a datatable
  35. What is a datagrid
  36. What are the three Ado objects
  37. What does connection string consists
  38. Where do you store connection string
  39. Can we have multiple datatables in a datareader
  40. What is datacolumn and how it is used
  41. How many commands does the oledbcommand takes
  42. What is the key feature of ADO.NET compared to ADO
  43. Which are the different IsolationLevels
  44. Difference between ADO and ADO.net
  45. What provider ADO.net use by default
  46. What does ADO.NET consists
  47. What are the steps in connecting to database
  48. ADO and ADO.NET differences
  49. What are the functions of oledbdataadapter
  50. Which type of database is used while processing dynamic database
  51. What is the difference between oledbreader and datasetwhile connecting
  52. How do we invoke queries from the application
  53. What is the provider and namespaces being used to access oracle database
  54. Write steps of retrieving data using ado.net
  55. What is ODP.NET
  56. How to sort the data in Datatable
  57. What are the different row versions available
  58. Explain acid properties
  59. Can you edit data in the Repeater control
  60. How to add Primary key in DataSet
  61. Explain what a diffgram is and its usage
  62. What are different types of Commands available with DataAdapter
  63. How to retrieve the third table value from the data set
  64. How to declare connection strings and how to make use of web.config
  65. What providers does ado.net uses internally
  66. What providers do you use to connect to oracle database
  67. What is sequence of code in retrieving data from database
  68. What is dataset and tell about its features. What are equivalent methods
  69. Call a stored procedure from ado.net and pass parameter to it
  70. About ado.net components/objects. Usage of data adapters
  71. Where does ADO.NET and XML web services come in the architecture
  72. Sequence to connect and retrieve data from database using dataset
  73. Can anybody show me the structure of ADO.NET
  74. Explain the ADO . Net Architecture
  75. How do you handle data concurrency in .NET
  76. How you will set the data relation between two columns
  77. What is data Adapter
  78. What is a dataview? why is it used for
  79. How do you filter the data in datagrid
  80. How do you sort the data in datagrid
  81. What is Execute Non Query
  82. Features and disadvantages of dataset
  83. What is execute scalar
  84. What is data access layer
  85. What is Sql Native Client
  86. What is the default view of Data Grid
  87. Difference between datareader and dataset
  88. Difference between Stored procedure and user defined functions
  89. What is sql Injection
  90. Differences between oracle 9i and sql server
  91. What is clustered index? why is it created
  92. What is trigger
  93. Can we execute trigger normally at the desired time
  94. If I want single result from sql server database then what command should i follow
  95. If a table contains 20000 records . In a page at each time 100 records t
  96. how will the server identify the errors
  97. What is the syntax code to oledb to connect oracle
  98. When we are running the Application, if any errors occur in the Stored Procedure
  99. How To Update A Column In A DataGrid Using C#.NET
  100. we want to connect to many databases layer such as MSAccess