Re: WinForms and local DB



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" <hssimpson@xxxxxxxx> wrote in message
news:uwPMXt7WFHA.2060@xxxxxxxxxxxxxxxxxxxxxxx
> 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?
>
> TIA
>
> Harry
>
>


.



Relevant Pages

  • Re: WinForms and local DB
    ... > XML file as physical storage and read all data in XML file into DataSet ... > have the DataSet stay in momery when the Windows app is running. ... >> spoiled by SQL Server and SQL Server CE. ... >> would be if I could make something like SQL Server CE local database work ...
    (microsoft.public.dotnet.framework.adonet)
  • where to save user settings in an app
    ... i've got an app that needs to connect to sql server and login with a ... my app saves this info in an XML file in plain ... developer trying to move to desktop app development, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: For Ilya Tumanov
    ... i mount the App in the iPAQ and works ok... ... "David Fúnez" wrote in message ... >> VS would redeploy and overwrite modified XML file. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: How to pass Application.Item value back to class?
    ... I just noticed that your message did mention that your prlbme was with ... Other classes must refer to the static "Current" member of ... > Suggestions please for strategy to share values across app. ... The xml file has different nodes for different ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Support of a large table
    ... > display different parts within different controls of a vb app. ... > One part of the XML file identifies information about processor cylces. ... > demanding on memory. ...
    (comp.lang.basic.visual.misc)