WinForms and local DB


Harry Simpson

I've been doing ASP.NET and PPC apps for years now. I've gone back to
revive an old application that used Access.

I'm witing it in VB.NET in VS2003 as a WinForms app. What's the local DB of
choice to use with this type of app. Is it still Access? I'm really
spoiled by SQL Server and SQL Server CE. I've even thought how neat it
would be if I could make something like SQL Server CE local database work on
the desktops. I want a database I can distribute and install with the app.

What's the general direction now....could I slam a 750 record table into an
XML file from access and ship it for simple data access lookup?



Norman Yuan

Never heard of MSDE (SQL2005Express)?

OTH, if you only have 750 records (each record is not too big), you can use
XML file as physical storage and read all data in XML file into DataSet and
have the DataSet stay in momery when the Windows app is running. Nowadays, a
desktop computer with a lot memory is very common. A few MB data stays in
memory should not be a big deal.

Harry Simpson

That was kinda my take on that too Norman. I just need to be able to query
the dataset but I can probably do that with filters....


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question