i want to know when i made win application and make setup project and include my project data i want to deploy ,,,,,,,,,,,, my question is about i made database with SQL Server 2005 express and connect it from visual studio 2005 as the same way we do when i install the application its read the database ,,,,,,,,,,,,, how is that amd the database source is on folder of sql server and not with my project ,,, can you explain that and also tell me about a good book or learning source for simple setup project for beginner developers thanks alot

If you are using SQL server, then as you know for connecting to SQL we will provide the connection string.

So after the user install your software he/she need to change the connection string so it will point to his/her database.

The best option is to add a App.config file to your existing project and place the connection string there.

You can read connection string from App.config using the System.Configuration namespace as

ConfigurationManager.ConnectionStrings["connectionstringname"].ConnectionString

---

Thanks,
A.m.a.L

.Net Goodies
[Remember to click "mark as answered" when you get a correct reply to your question]

so .... i want to know the people who developed win applications depened on database of SQL server 2005 ,,, how they deal with that ,,,,,,,,,,,,,, now i develop win form application and want install it on the user pc so ,, he will install sql server and what else my prog need ,,, so how can i change the connection string after i install my programe on my customer computer i just want to know the normal steps anybody do it when have sql server database will work with win form application ,,,

Recently i have developed a an application for one of my client. His requirement was a simple application which can be used to enter his daily transaction. I done the requirement analysis and feasibility study and found that he has a licensed Sql server. So i developed application with Sql as back-end.

I add a configuration file, place the connection string along with several application configuration.

I pubished my application and given EXE to client.

He installed, change the connection string.

:)

---

Thanks,
A.m.a.L

.Net Goodies
[Remember to click "mark as answered" when you get a correct reply to your question]

okay thats good ,,,, do you have any learning source could you provide me about configuration files
such the possible ways i can do my connection string with it

and also the way the my client can chnage the connection string ,,, to provide him with information that need to learn him how can change connection string on the configuration file

Storing and Retrieving Connection Strings

C# .NET what is the best way to read the connection strings

CodeProject: How to Store and Retrieve a ConnectionString from a ...

Storing Database Connection Strings in App.Config Tutorial in ...

---

Thanks,
A.m.a.L

.Net Goodies
[Remember to click "mark as answered" when you get a correct reply to your question]

oh ,,, thank you so much i will check that for now and am still developing my application and not deploy yet and maybe i will back to you later for help ,,,,,,,, thanks for help me for this parts

If you are using SQL server, then as you know for connecting to SQL we will provide the connection string.

So after the user install your software he/she need to change the connection string so it will point to his/her database.

The best option is to add a App.config file to your existing project and place the connection string there.

You can read connection string from App.config using the System.Configuration namespace as

ConfigurationManager.ConnectionStrings["connectionstringname"].ConnectionString

---

Thanks,
A.m.a.L

.Net Goodies
[Remember to click "mark as answered" when you get a correct reply to your question]

so .... i want to know the people who developed win applications depened on database of SQL server 2005 ,,, how they deal with that ,,,,,,,,,,,,,, now i develop win form application and want install it on the user pc so ,, he will install sql server and what else my prog need ,,, so how can i change the connection string after i install my programe on my customer computer i just want to know the normal steps anybody do it when have sql server database will work with win form application ,,,

Recently i have developed a an application for one of my client. His requirement was a simple application which can be used to enter his daily transaction. I done the requirement analysis and feasibility study and found that he has a licensed Sql server. So i developed application with Sql as back-end.

I add a configuration file, place the connection string along with several application configuration.

I pubished my application and given EXE to client.

He installed, change the connection string.

:)

---

Thanks,
A.m.a.L

.Net Goodies
[Remember to click "mark as answered" when you get a correct reply to your question]

okay thats good ,,,, do you have any learning source could you provide me about configuration files
such the possible ways i can do my connection string with it

and also the way the my client can chnage the connection string ,,, to provide him with information that need to learn him how can change connection string on the configuration file

Storing and Retrieving Connection Strings

C# .NET what is the best way to read the connection strings

CodeProject: How to Store and Retrieve a ConnectionString from a ...

Storing Database Connection Strings in App.Config Tutorial in ...

---

Thanks,
A.m.a.L

.Net Goodies
[Remember to click "mark as answered" when you get a correct reply to your question]

oh ,,, thank you so much i will check that for now and am still developing my application and not deploy yet and maybe i will back to you later for help ,,,,,,,, thanks for help me for this parts