Monday, January 7, 2008

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: