Intro to c# and ms sql

23 years old, and I still didn’t know how to connect a microsoft sql with c#
That needed to change!

In the end, it’s almost exact the same as php/mysql or in netbeans…
You define a connection, you open it, and you’re ready to query

The hardest part was getting the data source (my local computer) right ^^
Plus, you can connect using your windows credentials (just run it), or define some specific user authentication.

In code, it looks like this:

private void button2_Click(object sender, EventArgs e)
{
 SqlConnection myConnection = new SqlConnection("server=mendelportable\\sqlexpress;Trusted_Connection=yes;database=master;connection timeout=30");

 myConnection.Open();
 SqlCommand myCommand = new SqlCommand("select * from Table1", myConnection);
 SqlDataReader dr = myCommand.ExecuteReader();
 textBox1.Text = "";
 while (dr.Read())
 {
  textBox1.Text=textBox1.Text+dr["messages"].ToString()+"\r\n";
 }
}

And once you’re connected, you’re ready to query the hell out of that database

It’s absolutely nothing special, and it’s good to know!

Mission accomplished