Windows form - Connect SQL server

Question

Hi I want to done the following task : In windows formI 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?

Sanjeeb Lenka · Answer

hi check the attached sample. just change the connection string in .cs and check

Kavi suja · Answer

Hi SanjeebKiran kumarPrasenjit thank you all for your replies. I try this now..

Prasenjit Dey · Answer

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 Talikoti · Answer

Hi Check This Win Forms To Sql Connection Just Change The Connection String in App.config File and Give You Local System Path