title: how to convert odbc connection to sql connection?
body: <p>Right now I'm using this ODBC connection and it's working :</p>
  
  <pre><code>try
      {
          using (OdbcConnection connection = new OdbcConnection(ConfigurationManager.ConnectionStrings["MySQLConnStr"].ConnectionString))
          {
              connection.Open();
              using (OdbcCommand command = new OdbcCommand("SELECT * FROM datas", connection))
              using (OdbcDataReader dr = command.ExecuteReader())
              {
                  while (dr.Read())
                  {
                          switch (dr["namen"].ToString())
                          {
                              case "gt": Label2.Text = dr["dest"].ToString(); break;
                              case "gp1": Image1.ImageUrl = dr["dest"].ToString(); break;
                              case "gp2": Image2.ImageUrl = dr["dest"].ToString(); break;
                              case "gp3": Image3.ImageUrl = dr["dest"].ToString(); break;
                          }
                  }
                  dr.Close();
              }
              connection.Close();
          }
      }
      catch (Exception ex)
      {
          Response.Write("An error occured: " + ex.Message);
      }
  </code></pre>
  
  <p>I want to use SQL Connection so that I can fill datalist into it.</p>
  
  <p>PS: I think if I could use <code>ConfigurationManager.ConnectionStrings["MySQLConnStr"].ConnectionString</code> in 
  SQLconnection it will solve my problem. </p>
  
  <p>But I'm not able to think how to do it?</p>