How to make a set up of ASP.NET with C# and combined with SQL server 2005

[rhtdmrai]

Dear Sir/Mam

I am confuse to make setup in following points,

1. what is the connection string (basically the server name) to run it on various system.

2. what is the actual steps for doing this.

3. what files we have to save in our setup and how .

4. what software (viz. .net , sql)we needed to install into a system that have no sql server and .net; Can be any alternative in our setup to install these required setup automatically, when my setup run.

please help me.

thank you

[Frinavale]

1) The connection string ConnectionStrin g is a string that contains information about how to connect to the database. It typically includes the database location, the database name, database user credential information (user name, password, and type of authentication to use to authenticate the user). The connection string is going to vary between the type of database that you are connecting to. Since it contains sensitive information about your database you should take care in protecting this information by storing it in your web.config file and then encrypting the connection strings section.

2)? What do you mean what are the steps? A connection string is simply a String that contains information about the database. It can be used with .NET classes and controls to open a connection to the database so that you can run queries on the database. Please review the following articles that outline how to use a database:
Database tutorial Part 1
Database tutorial Part 2

3) Not sure what connecting to a database has to do with installation/setup applications. You should probably consider implementing your application first and then create your installation/setup application.


4) If you are developing an ASP.NET application, then you need to have the .NET Framework installed on the computer that will be hosting the application. The version of the .NET Framework that you software requires is going to depend on the version that you have selected to target and the version of Visual Studio that you are using.

As for a database suggestion: MS SQL requires you to purchase the software and a license to use it. This can be quite costly but has many benefits regarding security features etc that you may be interested in.

MySQL is a free database management system available that you can use...

You really should do research into the types of databases available to find the one that best suits your software requirement needs.

-Frinny