data options for application

[gordon]

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]

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/...mpleGuid=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/...09-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

 

[Otis Mukinfus]

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

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

 

[Guest]

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