I am a database developer, and started work on this site one day a week since January 2009. The "real" site will have far more tables, but for now I'm showing off the same method, using the Northwind Traders data.

Please check it out on http://www.fishwisepro.com/

The "Data" menu uses the grc.com CSS menus, and when you select one of the tables listed, you will see a browse form of all the records, using ASPxGridView. Try "Products" for example.

Click on the "Edit" button and the product details are displayed, using tabbed pages.

The drop-down foreign key entries (eg Category) are not data bound until you click on them.

One non-standard thing I have done is found when you click on the "+" sign for each record. In the case of Products, you will see "Order Details", which then displays all the order details for that particular product.

Please explore the web site, and report anything you manage to break. If you can break the security, PLEASE let me know.

 I noticed this when I was doing my demo. I fixed it by creating record key. It appears that if there is no unique ID for each row it does not  know which rows to select. I combined two columns in the query then hid them in grid. I don't know if this is te exact issue you are having. Maybe you need a hidden field OrderID + Prodcut ID

Testing has ended. Thanks everyone!

While I'm getting Fishwise to work, I have moved the Northwind Database stuff to a separate site

www.mustang.co.za

Please check it out, especially the help page www.mustang.co.za/help.aspx

This page demonstrates how the site is supposed to work, and then you can take a test drive. Use the login "Administrator" with password "administrator" if you want full editing rights.

The FishWisePro web site is live, with a lot of data in it. Unfortunately it is hosted by WedHost4Life, the hosting company that  broke the Ruby on Rails web site and thousands of others.

The mustang.co.za web site is also hosted by WH4L, but on older (faster) servers. It's a fiasco.

hey Donn.. did you consider simply using xaf for your efforts?

drew..:

hey Donn.. did you consider simply using xaf for your efforts?

XAF? I'm not sure what you mean. I'm using the ASPxGridView and it works very well.

xaf is DevExpress's amazing data/object framework. Check out http://devexpress.com/xaf/