How to generate automatic win-forms for SQL Server's tables?

3 Jul 2006 4:46 PM

ABC

I need to build many data enter forms for SQL Server's tables. Is there any
best methods to generate data forms from database table structure?

3 Jul 2006 5:49 PM

Michael Nemtsev

Hello ABC,

I suggest you to look at www.codesmithtool.com. You can create a script for
one table and it run it against all tables to get your forms from tables

A> I need to build many data enter forms for SQL Server's tables. Is
A> there any best methods to generate data forms from database table
A> structure?
A>
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

5 Jul 2006 8:17 PM

William Sullivan

The easiest way involves strongly typed datasets, data adapters and
datagridviews (definitely skip .NET 1.1 and do this in .NET 2.0, as the data
grid controls are much improved). Depending on what version of VS 2005 you
have, you can browse your database, pull the relevant tables right onto the
dataset design surface, and hook them right into a datagridview.

Unfortunately, "easy" is a relative term. If you are new to SQL, ADO, .NET
or even the whole programming thing, you've got a long way to go before you
can say that database programming is "easy."

Show quote

"ABC" wrote:

> I need to build many data enter forms for SQL Server's tables. Is there any
> best methods to generate data forms from database table structure?
>
>
>
>