SQL Server : database connection with textbox values

Question

I'm trying to make a application that connect to a SQL Server database with connection values from textbox but when I try connect it gives me connection error

error code: 40 - Could not open a connection to SQL server

Here is the source of the application:

private void ConnectToSQL() {
   string connectionString = @"Data Source=" + textBox4.Text + "Initial Catalog=" + textBox1.Text +"User ID=" + textBox2.Text + "Password=" + textBox3.Text;
using (SqlConnection objSqlConnection = new SqlConnection(connectionString)) {
    try {
        objSqlConnection.Open();
        objSqlConnection.Close();
        MessageBox.Show("Connection is successfull");
    } catch (Exception ex) {
        MessageBox.Show("Error : " + ex.Message.ToString());
    }

Please help me with this issue.

Thank you!

give break point and check the value of connectionstring and paste it here.. — Sasidharan
– Sasidharan, Commented Sep 4, 2013 at 5:09
Check out the SqlConnectionStringBuilder class instead of concatenating together your connectino string from textbox input... — marc_s
– marc_s, Commented Sep 4, 2013 at 5:13

sarwar026 · Accepted Answer · 2013-09-04 05:13:42Z

3

You have missed a semicolon(;) in your connection string. If you append it in your connection string, it should work.

string connectionString = @"Data Source=" + textBox4.Text + 
                           ";Initial Catalog=" + textBox1.Text +
                           ";User ID=" + textBox2.Text + 
                           ";Password=" + textBox3.Text;

answered Sep 4, 2013 at 5:13

sarwar026

3,8413 gold badges29 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

xeLin xel Over a year ago

Thank you. I used this .

marc_s · Accepted Answer · 2017-03-19 21:20:57Z

1

This might be due to you are missing semi columns in your connection string.

Try it as:

string connectionString = @"Data Source=" + textBox4.Text + ";Initial
Catalog=" + textBox1.Text +";User ID=" + textBox2.Text + ";Password="
+ textBox3.Text;

edited Mar 19, 2017 at 21:20

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Sep 4, 2013 at 5:13

C Sharper

8,66430 gold badges96 silver badges158 bronze badges

Collectives™ on Stack Overflow

SQL Server : database connection with textbox values

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related