How create A .exe file with SQL database and C# winform

HI there

I am working on a simple inventory project. I have used Visual Studio 2010 with C# cod and SQL Server 2008 for my project. my project is going to be finished but at the mean time i want to run the project on my collage PC but the collage PC is neither having Visual Studio and nor SQL server so i have created a setup file using visual studio installer. all was looking good. i install that setup file on Collage PC but when i tried to fetch the database the problem Starts. the software is not getting the database. here are my connection strings please check if i have to modify something.

this code is in my app.config file

"const"
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Data.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />

and below code i have used in form

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["const"].ConnectionString);

so the total form code is like this

public partial class Form1 : Form
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["const"].ConnectionString);
public Form1()
{
InitializeComponent();
}
private void Login_Click(object sender, EventArgs e)
{
SqlDataAdapter sda = new SqlDataAdapter("Select Count(*) From Login where Username='" + username.Text + "' and Password='" + password.Text + "'", con);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows[0][0].ToString() == "1")
{
this.Hide();
Main ss = new Main();
ss.Show();
}
else
{
MessageBox.Show("please check Username and Password");
}
}
}

this is for login page cade..

please suggest need urgent help.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Relebohile Nkosi7y ago
Hopefully you've managed to solve this already but the problem seems to be the database credentials... Make sure that they match those of your colleague's pc by editing the connection string
Mangesh G8y ago
Praveen understand the process it is Possible but it will Increase the Overhead On your application so it is Better to Install it before Putting your application On the machine

and then open a wizard which will connect these databse
i would not recommend to automatically install the Database from Application
Praveen Maurya8y ago
Mangesh.. How?? is there any way to do it automatically when i install the Setup file.
Mangesh G8y ago
u need to install the Database on the system where u are running application and change the connection string accordingly