Simple SQL Server database connection and reading a table on C#

Question

I am new at this but I have a simple table in my SQL Server with one column name and 2 rows in it. I am trying to show up the names when pressing a button, I need to know how to connect the SQL Server database to the C# code and how to read from a specific table.

namespace WinFormsApp1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string connetionString;
            SqlConnection cnn;
            connetionString = @"Data Source=DESKTOP-REB699D\SQLEXPRESS;Initial Catalog=DBdemo";
            cnn = new SqlConnection(connetionString);
            cnn.Open();
            MessageBox.Show("Connection Open  !");
            cnn.Close();
        }
    }
}

But that didn't work, it crashes at the cnn.open(); line of code.

What @LarsTech says and then some guessing. You are trying a remote connection? Initially MSSQL Express only allows local access (TCP\IP is disabled). — Ralf
– Ralf, Commented Oct 6, 2022 at 15:15
System.Data.SqlClient.SqlException: 'A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)' — Mahmoud Farid
– Mahmoud Farid, Commented Oct 6, 2022 at 15:15
Use the edit link under your question to include that information. — LarsTech
– LarsTech, Commented Oct 6, 2022 at 15:16
Your connection string does not contain any information related to authentication like User Id=myUsername;Password=myPassword; or Trusted_Connection=True; or Integrated Security=true;. See SQL Server connection strings — Olivier Jacot-Descombes
– Olivier Jacot-Descombes, Commented Oct 6, 2022 at 15:26

WisdomSeeker · Accepted Answer · 2022-10-06 16:08:47Z

3

If you are not using any credentials, its windows authentication.

Does adding Integrated Security=True to the connection string help?

Can you login to the DB without credentials on SSMS using Windows authentication option? If so, you don't need user credentials for connecting to DB. If you require a Username and password there,

you either need to include that in the connection string or
you need to enable SQL Server and Windows Authentication option under security tab to access the database without credentials

edited Oct 6, 2022 at 16:08

answered Oct 6, 2022 at 15:56

WisdomSeeker

9446 silver badges8 bronze badges

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

1 Comment

Mahmoud Farid Over a year ago

i tried integrated security and it worked ,thank u so much

Collectives™ on Stack Overflow

Simple SQL Server database connection and reading a table on C#

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related