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.