SQL Server cannot build connection string to db

Question

I tried the following in SQL Server Management Studio; I can connect and run query, but not from my project

string s = "Server=LAPTOP-7J47C5JA\SQLEXPRESS;Database=Test;Trusted_Connection=True;";

string queryString =   "SELECT * from tbclienti";

cn = new SQLConnection(s);

// Create the Command and Parameter objects.
SqlCommand command = new SqlCommand(queryString, cn);

cn.Open();

SqlDataReader reader = command.ExecuteReader();

while (reader.Read())
{
    Text = reader[0].ToString();
    label1.Text = reader[1].ToString()+ " " + reader[2].ToString();
}

reader.Close();
cn.Close();

it comes a window with a list of processes., It'not proerly an an error — user1238784
– user1238784, Commented Apr 8, 2018 at 10:19
Lets try first connection string. Is it connecting to db ? string s = @"Server=(local)\SQLEXPRESS;Database=Test;Integated Security=SSPI;"; — Mirko Acimovic
– Mirko Acimovic, Commented Apr 8, 2018 at 10:26
using(SqlConnection cn = new SqlConnection(s)) { try { cn.Open(); }catch(Exception ex) { } } — Mirko Acimovic
– Mirko Acimovic, Commented Apr 8, 2018 at 10:28
it gives error the name cn does not exist in the context windowsfromapp2 — user1238784
– user1238784, Commented Apr 8, 2018 at 10:36

Mirko Acimovic · Accepted Answer · 2018-04-08 10:50:43Z

2

I posted here whole code what could look like. Try it now.

    string s = @"Server=(local)\SQLEXPRESS;Database=Test;Integrated Security=SSPI;";

    using(SqlConnection cn = new SqlConnection(s))
    {
        string queryString = "SELECT * from tbclienti";

        try
        {    
          cn.Open();
          // Create the Command and Parameter objects.
          SqlCommand command = new SqlCommand(queryString, cn);
          SqlDataReader reader = command.ExecuteReader();
          while (reader.Read())
          {
             Text = reader[0].ToString();
             label1.Text = reader[1].ToString()+ " " + reader[2].ToString();

           }
           reader.Close();
         }
         catch(Exception ex) 
         {
             // see if error appear
         }
         finally
         {
           cn.Close();
         }
    }

edited Apr 8, 2018 at 10:50

answered Apr 8, 2018 at 10:43

Mirko Acimovic

5062 silver badges9 bronze badges

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

2 Comments

user1238784 Over a year ago

THANKS NOW IT WORKS: i ONLY ADDED @ IN FRONT OF THE CONNECTION STRING

Mirko Acimovic Over a year ago

Ah those backslashes :). Im glad it worked. If you dont put @ you need two backslashes like \\

Collectives™ on Stack Overflow

SQL Server cannot build connection string to db

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related