In my application i have database connection
but i dont know how to attach my database with application
Front End : C#.Net
Back End : SQL server 2005
I need to create a setup to run my application on another machine ....
sathish88
0
Newbie Poster
Recommended Answers
Jump to PostThis is a base example of using connection string, but it works:
static string connString = @"Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;"; private YourMethod() { using (SqlConnection sqlConn = new SqlConnection(connString)) { sqlConn.Open(); //do inquieries: string sqlQuery = @"SELECT ... FROM ... WHERE"; } }Use your correc connection …
All 3 Replies
Mitja Bonca
557
Nearly a Posting Maven
This is a base example of using connection string, but it works:
static string connString = @"Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;";
private YourMethod()
{
using (SqlConnection sqlConn = new SqlConnection(connString))
{
sqlConn.Open();
//do inquieries:
string sqlQuery = @"SELECT ... FROM ... WHERE";
}
}Use your correc connection string!
muzikhera
-2
Junior Poster in Training
Just simply add your database in your setup project in order to include the database during installation.
mono_jit23
1
Junior Poster in Training
Use dynamic connection string rather than hard code. Get your connection string from settings file all the time. then you can simply create your setup file and install into client machine. After installation just change the setting file as per the client info (You can find it in installation folder and then open it with any text editor).
For your Database just get a backup and restore it to client machine or make a script.... :(
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.