Houston Chronicle

How to Establish an ODBC Connection to the SQL Database

Windows 7 includes an ODBC manager that lets you connect from your desktop to a SQL server. You create a data source name (DSN) to save database setup information, so you can open a connection to the ...
Houston Chronicle

How to Bind a WPF Listbox to an SQL Table

A WPF ListBox lets you display data created and stored in a SQL table. You must query the SQL database, and you use the retrieved data set to populate the ListBox items. The SQL table can contain one ...
Ars Technica

How to Migrate Data from an AS/400 to SQL server?

We have an ancient AS/400 730 system that still houses some old budget/financial data. We'd like to decommission this box, and migrate the data to a SQL server. The data won't be modified or changed ...
Ars Technica

Exporting SQL data to Excel spreadsheet via web page click

I would like the user to be able to click a button on the web page that will run a SQL query (canned report) and export the result data to an Excel spreadsheet. The data does not need to display on ...