DaniWeb Forum Index > Software Development > C#

how to add database into the while iam deploying.

Please support our C# advertiser: Intel Parallel Studio Home

•

Join Date: Apr 2008

Posts: 7

Reputation: prabhuraj is an unknown quantity at this point

Solved Threads: 0

prabhuraj

Offline

Newbie Poster

how to add database into the while iam deploying.

Apr 24th, 2008

may i know how to add sqlexpress database to my visual studio project while iam deploying...
(i tried by simply adding database into my project through solution explore before deploy , but while instaling deployed project into client machine ,on that time i cant access the data's from database.)
can you tell me how to do this process in detail.

•

Join Date: Apr 2008

Posts: 47

Reputation: Jens is an unknown quantity at this point

Solved Threads: 5

Jens

Offline

Light Poster

Re: how to add database into the while iam deploying.

Apr 24th, 2008

Try to put your connectionstring in a config - file. This way you'll be able to edit it specifically for the machine you want to install it on.

In you config- file it should look a bit like

 Help with Code Tags 
 xml Syntax (Toggle Plain Text) 
<connectionStrings>
    <add name="nameconnstring" connectionString="connstring" providerName="System.Data.SqlClient">
</connectionStrings>
<connectionStrings>
    <add name="nameconnstring" connectionString="connstring" providerName="System.Data.SqlClient">
</connectionStrings>

I think.
In your program you'll have to reference the system.configuration library. After that you can retrieve the whole connectionstring with:

 Help with Code Tags 
 c# Syntax (Toggle Plain Text) 
        static String ConnectionString = ConfigurationManager.ConnectionStrings[<name or index>].ToString();
        static String ConnectionString = ConfigurationManager.ConnectionStrings[<name or index>].ToString();

Hope this helps, jens

Last edited by Jens; Apr 24th, 2008 at 4:57 am.

•

Join Date: Nov 2006

Posts: 436

Reputation: JerryShaw is on a distinguished road

Solved Threads: 72

JerryShaw

Offline

Posting Pro in Training

Re: how to add database into the while iam deploying.

Apr 25th, 2008

Is the database getting installed ? IOW can you access it using SQL 2005 Studio on the client machine ?

If this is a question about connection strings (IOW the database is verified to be installed on the client and functional), then "Jen"'s answer should be all you need.

If your question involves the installation of the database on the client computer then read on:

If this is an SQL database, I suggest that you use an install package that knows what it is doing with SQL.

Typically using a T-SQL script has a better success rate, however if you know what you are doing, you can use the Attach datebase functionality of T-SQL (through ADO...other). The issues there are that you must make sure you have no special schemas created (created against a non existing user) , Simple file structure (aka not using FileGroups / database partitioning) and no database users assigned where the SID will not match.

// Jerry