Need Grid that Emulates Excel Data Filter

[clarkbaker1964]

Hi guys I am looking for a prebuilt tool that provides the following functionality:

Choose Server, Database, Table
From this the tool

Populates a data grid with all columns in the underlying table.
Header for every column with Combobox populated with Distinct values from the of the grid data.
Can Filter the grid based on selecting a value accepts wild cards in the filter.

This functionality exists in the Excel Data Filter but hear is where excel fails:

Ability to edit the data saving the changes back to the database and generate the SQL Script

Has anyone built a Grid that already does this?
This is a buy versus build (using grid components like True DB Grid)

[robertx]

Have a look at the XTraGrid at the Developer Express site:

http://www.devexpress.com/

This is a terrific component and does everything that you want it to.

You can download a trial version which displays a splash screen each time you start the project. You receive user-friendly sample projects and the online documentation is very good.

If you use the XtraForms, you can also do stuff like changing the skin (appearance) of the grid which adds a real professional touch.

If you decide to give it a go, I have written some procedures (in VB.NET) to create columns, column headers, load the grid with data from a database etc. so I can help you cut a few corners.