Saturday, January 5, 2008

FAQs on ADO.Net

Write a Generic Data Access Component which selects a data provider at run time?
Transfer data from a SQL Server database to an Excel database?
Create a Custom Data Provider?Bind IList to a DataGrid?
Use DiffGrams in a DataSet? Data Binding in DataGrid Control?
How to I get the modified rows (deleted, added, updated) of a DataSet?
Send only affected rows of a DataSet to the database when saving results?
Make DataSet save operation faseter? Get rid of '+' sign from a DataGrid?
Get all tables of a database programmatically?
Get all columns of a table without using DataSet?
Get a list of all available tables of an Access database?
Update a database using DataSet? Add ComboBox to a DataGrid?
Add CheckBox to a DataGrid?
Use Date or DateTime values in a SQL statement?
Create a SQL Server database programmatically?
Read data from a database using ADO.NET?
Write data to an access database using SQL Query and ADO?
Use DataGrid to display data from a table?
Get a database table's column properties such as name, type etc?
I'm having problem connecting MySQL Server using ODBC .Net Data Provider. Get a list of available ODBC DSNs using ADO.NET?
Is there any sample available to connect to MySQL Server?
Navigate through database records in an unbound DataGrid control?
Transfer data from SQL Server to Excel? Create my own Data Adapter?
View an Oracle database tables and their contents? Connect to an Oracle database?
Access an Oracle database? Select, add, update and delete data from a database?
Display data in a ListBox Web Control? Access data from Text files using ADO.NET?
Read data from a relational database and write to XML Files?
View data in a DataGrid control in a simple way?
Get a database table properties programmatically?
Write data to an access database using SQL statement?
Open and Read Excel Spreadsheet into a ListView Read and save Images in a SQL Server database using ADO.NET?
Call Oracle Stored Procedure with Parameters in ASP.NET and ADO.NET?
Add records to an Access database with a Stored Procedure?
Execute Stored Procedures?
Execute Views?
Retrieve data from multiple database tables in a DataSet?
View data from multiple database tables in a DataGrid control?
Check if a database table has no records? Bind two fields of a table to a ListBox control?

No comments: