Rapid Data Forms Development
I discovered a quick and dirty way to manipulate DB
tables using .Net Windows forms. "Drag and Drop"
1. Drag a table from "Server Explorer" and automatically get a connection and dataAdapter object
2. You can use the dataadapter object to generate a typed datasets
3. Drop a Datagrid on the form and and set it's datasource to the dataset
4. Couple of buttons 4 lines of code (bit more if you want lookups as well)
1. Drag a table from "Server Explorer" and automatically get a connection and dataAdapter object
2. You can use the dataadapter object to generate a typed datasets
3. Drop a Datagrid on the form and and set it's datasource to the dataset
4. Couple of buttons 4 lines of code (bit more if you want lookups as well)
and you got yourself a pretty neat data entry form for
that table.
Average time to develop per form 5 minutes.
Also the "Data Form Wizard" is pretty neat too, the only
limitation being that it can't seem to handle multiple
tables.
Another useful trick is the Connection and DataAdapter
wizards (when you drag connection and adapter objects onto
your form) which allow you to generate completely
customized objects.
Looking forward to seeing what improvements are in store
in Whidbey.