Hi
I have an application that currently uses ado.net to read some files and
populate a datagrid. The app allows users to search and return values based
on a 'like' parameter in a select statement.
The data files have always been provided to me in MSAccess format and users
have Access on their desktop (ie therefore it has been efficient to use the
JET engine). I don't think that many users have local admin rights or SQL
server.
Now many users have lost MSAccess. I would like to find some alternatives
for my application.
My data has about 3000 rows and 6 columns - 2 of the columns contain text.
I am not expereinced with xml - but I can learn- but I was wondering if
there are alternatives out there that I could use?
Thanks
Doug
sloan - 29 Sep 2006 22:00 GMT
Do you want different options for the DataStore?
Or for accessing the Access database?
For a different DataStore:
MSDE (a Sql server 2000 "lite" version)
SqlExpress (2005 "lite" version)
As far as talking/accessing an Access database:
And since you already have the data in an Access format, then ABANDON
Jet/DAO. I repeat, ABANDON Jet and Dao.
Check this site:
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=137F13F8-
AA21-4042-BAB1-3781DF71DCDD
Which allows you to add OleDB ability to the June 2005 1.1
EnterpriseLibrary.Data library
http://www.microsoft.com/downloads/details.aspx?FamilyId=A7D2A109-660E-444E-945A
-6B32AF1581B3&displaylang=en
You do NOT need to have Access (the program) installed to talk to an Access
database.
............
You should also google "strongly typed datasets", and learn about the
DataSet.ReadXml and DataSet.WriteXml methods.
http://www.awprofessional.com/articles/article.asp?p=29901&seqNum=4&rl=1
> Hi
>
[quoted text clipped - 18 lines]
>
> Doug
Otis Mukinfus - 29 Sep 2006 22:27 GMT
>Hi
>
[quoted text clipped - 18 lines]
>
>Doug
SQL Server Express might be the answer:
http://www.microsoft.com/sql/editions/express/default.mspx
Good luck with your project,
Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com
Peter Bromberg [C# MVP] - 30 Sep 2006 01:44 GMT
Gordon,
For something that lightweight, I'd recommend a look at the SQLite database
engine. You can get a single .NET assembly with the database engine and the
ADO.NET 2.0 provider in a single file, and it requires ZERO installation:
http://sqlite.phxsoftware.com/
Peter

Signature
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com
> Hi
>
[quoted text clipped - 18 lines]
>
> Doug