Getting data in and out of a Many To Many join table can be tedious and take a ton of time. This control can hopefully help you save a little.. This is a checkbox list that helps you to admin many to many relationships in your database. For this to work, you need to specify a mapTableName (in other words, the joining table), a primaryTableName (in other words the table with the primaryKey from which you're working), a primaryKeyValue, and the foreignTableName (the other end of the many to many from the primaryTableName). If, in Northwind, there was a many to many between Products and Categories...

A simple, DB-Powered drop down DropDown is a simple dropdown list that is loaded for you. One of the simplest things to do! If you want a select list of categories, you simply use: <subsonic:DropDown tableName="Categories" id=elThing runat=server> With this command SubSonic will query ONLY TWO FIELDS in the Categories table - the primary key and the field in ordinal position 1 (which by our convention should be the descriptor). If you don't like that, you can override what we think and specify "textField=thisOtherColumnName". The point is we don't "SELECT *". You can also do these things...

The QuickTable allows you to quickly expose data in a sensible way. It features server-side paging, sorting, and a nice look and feel. The QuickTable gets data from a table or view and displays it without the ViewState monster of DataGrid or GridView. This is meant just to quickly show some data in a tabular format if you don't need all the other stuff from DGs and GVs. It also allows sorting straight away, and paging too: Server Side Paging . This guy is ideal for large tables. You can show only the columns you want by defining a column list: ColumnList="ProductID, ProductName" You can change...

The term "scaffolding" is from Ruby On Rails, and is essentially a full set of "CRUD" pages for you to enter and manipulate data in your database. Initially, scaffolding was not meant for public use, rather your use as a develeloper to enter and use data quickly. We are moving in the direction however of outputting the scaffolds to an actual page so that you can create and customize editors as needed. Using our scaffold is simple - just point it to a table in your database and off you go: <cc1:Scaffold ID="Scaffold1" runat="server" TableName="Products" /> This will setup a table and editor...