Jump to content

C# - Relative Data Source


greenApple

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...