Windows form - Connect SQL server

Kavi suja

Hi,
I want to done the following task : In windows form,I have button. when i click that button it will connect to database(SQL Server).How i express this? I want to display it in the label as "Database connected" , "Database not connected". Can anyone give me idea to do this?

4 Replies

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

Sanjeeb Lenka13y ago
Accepted answer
hi,

check the attached sample.

just change the connection string in .cs and check
Kavi suja13y ago
Hi,
Sanjeeb,Kiran kumar,Prasenjit thank you all for your replies. I try this now..
Prasenjit Dey13y ago
Use the code

private void button1_Click(object sender, EventArgs e)
{
string _connectionstring = @"Data Source=localhost;Initial Catalog=TestDB;Integrated Security=True;user id=sa;password=123";
SqlConnection con = new SqlConnection(_connectionstring);
con.Open();

if (con.State == ConnectionState.Open)
{
MessageBox.Show("Database Connected");
}
else if (con.State == ConnectionState.Closed || con.State == ConnectionState.Broken)
{
MessageBox.Show("Database not connected");
}
}

Now you have to just change the connection string
Kiran Kumar Talikoti13y ago
Hi Check This Win Forms To Sql Connection,

Just Change The Connection String in App.config File and Give You Local System Path,