program that will create a local database?

[Wiesjahnn]

Hello I have a quick "Is this possible?" question.

Im looking to design a program that will create a local database and be able to add and edit information and all that jazzy jazz. Is this possible in VB.Net alone or will I need some sort of SQL software as well.

Thanks in Advance.

 

[JuggaloBrotha]

That depends, what do you mean by local database. Do you mean a local sql server/msde setup or something even simpler like an Access DB?

 

[Wiesjahnn]

Basically a small DB with tables to hold information and stats for a sports team
so access would probably be sufficient. I just want the user to be able to use it and not have to have access if that is at all possible.

 

[JuggaloBrotha]

Sure, one way to do it would be to build an empty database (by empty I mean make the Tables, Queries and relationships) and distribute that with the app.

If it needs to be dynamic you can include a completely (or partially) empty DB and use SQL statements to create the new tables on the fly or you can use ADOX to create the database and again use SQL to make the tables.

Personally I would go with the former rather than the latter, I especially try to not use ADOX if I can.

 

[Tom]

You can write your data to an XML file and then import it to a dataset and work with it just like a database.

 

[cjard]

I think Tom's suggestion may be sufficient for your needs; using a DataSet readxml/writexml like a "cheap" database. If you want to have an Access MDB you'll struggle to create it yourself from nothing. I'd recommend you design and create a small, empty MDB to bundle with the app, having all the tables but none of the data
Don't forget to compact/repair your DB BEFORE you ship your app

 

[mbb]

You could try SQL Server Compact.