You have to remember that dbf are flat file databases and can be very
portable. SQL Server as in SQL Server 2005 Express is a full blown Database
Server. To create a database with this you have to first fire up the
management tools and create the database there, then you have to allocate
the permissions to that database. Once this is done you can then go to your
Visual Studio server manager and connect to your database, From there you
create the tables, stored procedures, and such.
To create stand alone database files (*.mdb) these are just access database
files and you have to ways to create them. the first is to use access to
create the DB, or use ADOX (Witch is unmanaged). To find out about ADOX you
will most likly have to go the the dotnet database groups to get some code.
"Wilfried Mestdagh" <Wi**************@discussions.microsoft.com> wrote in
message news:03**********************************@microsof t.com...
Hi Glenn,
For creating the Tables and Such you will need to look at TSQL. Or look
at
using the SQL-DMO Classes.
Not simple :(
I'm coming from Delphi. If I wants to create a project with a local
database
in any format it take me 30 seconds mouseclicks and the project is up and
running, creating his own files at customar.
Maybe I'm missing something. Can you recommand me some example ? Unless
I'm
totally wrong it seems I go back in time 20 years using dbf in .net coding
everyting.... (I hope I'm wrong :)
--
rgds, Wilfried
http://www.mestdagh.biz