By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,896 Members | 2,002 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,896 IT Pros & Developers. It's quick & easy.

data options for application

P: n/a
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
Sep 29 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a

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/U...1-3781DF71DCDD

Which allows you to add OleDB ability to the June 2005 1.1
EnterpriseLibrary.Data library
http://www.microsoft.com/downloads/d...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/articl...&seqNum=4&rl=1


"gordon" <go**********@optusnet.com.auwrote in message
news:45***********************@news.optusnet.com.a u...
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


Sep 29 '06 #2

P: n/a
On Sat, 30 Sep 2006 06:10:12 +1000, "gordon" <go**********@optusnet.com.au>
wrote:
>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/edition...s/default.mspx
Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com
Sep 29 '06 #3

P: n/a
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

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"gordon" wrote:
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
Sep 30 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.