"database wizard"

[brain2cpu]

In old days In FoxPro could generate a page for a given table with edit boxes for every field, some navigation buttons, add, delete, find - all this without too much typing Is there something like that for C# ? Datagrid is not an option here because of validations, auto-calculated fields and user preferences :mad: I have a lot of tables with a lot of columns and to create all forms is just overkill. Any hints please? Thanks

[Heath Stewart]

C# is a programming languages that targets the Common Languages Runtime. FoxPro is a complete database application environment so it has a lot of bells and whistles like that. The DataGrid can do all those things you want by overriding key functionality. I suggest you thoroughly examine the methods and properties of the DataGrid. As far as user preferences are concerned, this is not even an issue. As with all preferences, you change the the object in question when either initializing or update it when preferences change. Windows Forms uses data-bound controls. You can drag-and-drop a table to your form which will create the necessary connection and command objects (although it'd be better to create a new DataSet class (Add New->Class->DataSet) in your project and drag the tables to the designer's surface, then drag the DataSet component from the Component toolbox and select your strongly-typed DataSet. Then you add the appropriate controls to your form, go to the DataBindings category and click the "..." button. The UI is pretty intuitive. You can find more information by reading some of the articles in the .NET Framework SDK.

-----BEGIN GEEK CODE BLOCK----- Version: 3.21 GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++ -----END GEEK CODE BLOCK-----