Question asp.net connection string?

[darksyntax]

Ok I am a web intern tasked with building an asp.net form that would make filling the holes found in products table of the shopsite_db database easier. I have never dealt with sqlight. Can someone point me in the direction of correct and working connection string?

[loren_d_c]

Try google'ing for it. By searching for the term 'using SQLite with asp' I found a link that may be of interest to you:

http://www.eggheadcafe.com/tutorials/as ... e-wit.aspx

And of course there thousands more search results, so if that doesn't help you there may be something else that will.

-Loren

[VDCUSA]

Hi Loren. I am working with "darksyntax" on this project. Thank you for that suggestion. However when visiting the link at

http://www.eggheadcafe.com/tutorials/as ... e-wit.aspx
the entry directs us to this resource:

Information and download of System.Data.SqLite:
http://sqlite.phxsoftware.com/

We have already visited this site, and found that Visual Web Developer Express 2008 does not support the plug-in.

Can anyone AT SHOPSITE or on this forum address this? Wondering why we are even having to use SQlite instead of standard MS SQL ?

In a nutshell, we need:
A connection string that allows us to transfer to and from the ShopSite DB, within ASP.

any help, ideas with that is greatly appreciated. this is business critical, and stopping a very important db project with our ShopSite implementation.
THANK YOU!
Michelle
Dir. Web Operations

[loren_d_c]

ShopSite uses SQLite because it is cross-platform (Windows is not the only OS ShopSite is on) and because it is a file-based SQL system that doesn't require any separate services to be run/administered on the server.

I don't have any answers for your specific platform or programming interface, sorry. I don't know anything about ASP.NET specifically, or Visual Web Developer Express 2008.

Note that ShopSite does not support direct access to the shopsite_db file at all. Although it is certainly possible for you to do so because it is a common/open format used by thousands of applications. I would recommend checking out some of the other thousands of Google search results, if this one particular one was not of use to you.

-Loren

[robm]

You could use the auto XML upload/download built into ShopSite to transfer data to/from ShopSite from a DB such as MS SQL. Simply download the data as an XML file, parse this into MSSQL, query SQL directly, and then you can upload any changes from your DB into ShopSite via the auto XML upload:

http://www.shopsite.com/help/9.0/en-US/ ... pload.html