Ado.net Sql Connection

Question

I try to make Sql connection using Ado.Net. I create a ConsoleApplication and get the Name and UnitPrice values from my database. After execution Console says can not open a connection. What is wrong that I make ?

Here is my code:

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

class ConsoleApplication1
{
    static void Main()
    {
        string connectionString =
            "Data Source=EMINCIFTCI/EMIN;Initial Catalog=Ado;User ID=sa;Password=10203040";


        string queryString =
            "SELECT Name, UnitPrice from dbo.Product "   
                + "ORDER BY UnitPrice DESC;";

        using (SqlConnection connection =
            new SqlConnection(connectionString))
        {

            SqlCommand command = new SqlCommand(queryString, connection);

            try
            {
                connection.Open();
                SqlDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    Console.WriteLine("\t{0}\t{1}",
                        reader[0], reader[1]);
                }
                reader.Close();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            Console.ReadLine();
        }
    }
}

Can you provide proper connection string from for example MS SQL Server Managment Studio ? — Aleksandr Zolotov
– Aleksandr Zolotov, Commented Dec 1, 2016 at 9:18
Search the exception in google and you will find your problem. — mybirthname
– mybirthname, Commented Dec 1, 2016 at 9:21
My suggestion is Initial Catalog=Ado but most probably connection string issue — Emad
– Emad, Commented Dec 1, 2016 at 9:31

Tieson T. · Accepted Answer · 2016-12-01 10:20:53Z

3

Assuming EMINCIFTCI/EMIN is your computer name and (I assume) SQL Server instance, you need to swap the forward slash with a backslash (two, technically, unless you use a verbatim string).

So, use either

string connectionString =
            "Data Source=EMINCIFTCI\\EMIN;Initial Catalog=Ado;User ID=sa;Password=10203040";

or

string connectionString =
            @"Data Source=EMINCIFTCI\EMIN;Initial Catalog=Ado;User ID=sa;Password=10203040";

You may want to review https://www.connectionstrings.com/

answered Dec 1, 2016 at 10:20

Tieson T.

21.2k6 gold badges82 silver badges99 bronze badges

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

1 Comment

Emin Çiftçi Over a year ago

Thanks for helping. I made a mistake with data source. It is working now

Sudip Bhattacharya · Accepted Answer · 2016-12-01 10:23:37Z

0

I think the connection string should be proper"Data Source=EMINCIFTCI/EMIN;Initial Catalog=Ado;User ID=sa;Password=10203040;"

There should be semicolon in the end

answered Dec 1, 2016 at 10:23

Sudip Bhattacharya

737 bronze badges

Collectives™ on Stack Overflow

Ado.net Sql Connection

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