greenApple Posted April 1, 2011 Share Posted April 1, 2011 I currently have my data source hard coded, is it possible to have a relative data source so that I can run it on a number of computers? All files are stored in a folder, with my database stored within an App_Data folder.My current code: //create connection to database SqlConnection connection = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Users\\greenApple\\Desktop\\new_forum\\App_Data\\members.mdf;Integrated Security=True;User Instance=True"); SqlCommand cmd; protected void Availability_Click(object sender, EventArgs e) { connection.Open();//open connection cmd = new SqlCommand("SELECT * FROM member WHERE username='" + txtUserName.Text + "'", connection);// sql command to read from members table } protected void btnRegister_Click(object sender, EventArgs e) { connection.Open();//open connection cmd = new SqlCommand("INSERT INTO member (username, password) VALUES ('" + txtUserName.Text + "','" + txtPassword.Text + "')", connection); cmd.ExecuteNonQuery(); } Any help would be great!! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.