title: How to run multiple SQL commands in a single SQL connection?
body: <p>I am creating a project in which I need to run 2-3 SQL commands in a single SQL connection.
  Here is the code I have written: </p>
  
  <pre><code>SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\project.mdf;Integrated Security=True");
  con.Open();
  SqlCommand cmd = new SqlCommand("select *  from " + mytags.Text + " ", con);
  SqlDataReader rd = cmd.ExecuteReader();
  if (rd.Read())
  {
      con.Close();
      con.Open();
      SqlCommand cmd1 = new SqlCommand("insert into " + mytags.Text + " values ('fname.lname@gmail.com','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','"+mytags.Text+"')", con);
      cmd1.ExecuteNonQuery();
      label.Visible = true;
      label.Text = "Date read and inserted";
  }
  else
  {
      con.Close();
      con.Open();
      SqlCommand cmd2 = new SqlCommand("create table " + mytags.Text + " ( session VARCHAR(MAX) , Price int , Description VARCHAR(MAX), Date VARCHAR(20),tag VARCHAR(10))", con);
      cmd2.ExecuteNonQuery();
      con.Close();
      con.Open();
      SqlCommand cmd3 = new SqlCommand("insert into " + mytags.Text + " values ('" + Session + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + mytags.Text + "')", con);
      cmd3.ExecuteNonQuery();
      label.Visible = true;
      label.Text = "tabel created";
      con.Close();
  }
  </code></pre>
  
  <p>I have tried to remove the error and I got that the connection is not going to else condition. Please review the code and suggest if there is any mistake or any other solution for this.</p>