title: How to fix "Keyword not supported: 'port'." in C# using DataSets
body: <p>i'm new in C# and i want to generate crystal report in C# but it shows an error message &quot;Keyword not supported: 'port'.&quot;.
  The error is occured at  <code>SqlConnection conn = new SqlConnection(sme_erpConnectionString); </code>For the database, im using MariaDb
  Please anyone know how to fix this? I already search in the internet but still got error. Thank you.</p>
  <p>Here is my CrystalReportDemoController</p>
  <pre><code>public class CrystalReportDemoController : Controller
      {
  
          protected static string erpConnectionString= ConfigurationManager.ConnectionStrings[&quot;erpConnectionString&quot;].ConnectionString;
  
          // GET: CrystalReportDemo
          public ActionResult Index()
          {
              return View();
          }
          public ActionResult downloadReport()
          {
              var _data = new List&lt;EmpData&gt;();
              CrystalReport1 cr = new CrystalReport1();
              SqlDataReader dr = ExeQuery(&quot;table_customer&quot;);
              if(dr.HasRows)
              {
                  while (dr.Read())
                  {
                      var x = new EmpData()
                      {
                          id = int.Parse(dr[&quot;id&quot;].ToString()),
                          item_master_cd = dr[&quot;item_master_cd&quot;].ToString(),
                      };
                      _data.Add(x);
                  }
              }
              cr.SetDataSource(_data);
              Class1.PassData = cr;
              return Redirect(&quot;~/Report/ReportCrystal.aspx&quot;);
          }
          private SqlDataReader ExeQuery(string str)
          {
              SqlDataReader dr = null;
              SqlConnection conn = new SqlConnection(erpConnectionString);
                  conn.Open();
                  using (SqlCommand cmd = new SqlCommand(str,conn))
                  {
                      cmd.CommandType = CommandType.Text;
                      cmd.CommandTimeout = 50000;
                      dr = cmd.ExecuteReader();
                  }
              return dr;
          }
          public class EmpData
          {
              public int id { get; set; }
              public string item_master_cd { get; set; }
          }
      }
  }
  </code></pre>
  <p>Web.config</p>
  <pre><code>&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;
  &lt;!--
    --&gt;
  &lt;configuration&gt;
    &lt;connectionStrings&gt;
      &lt;add name=&quot;erpConnectionString&quot; connectionString=&quot;server=xx.x.xx.xx;user id=mydb;password=mydb123;persistsecurityinfo=True;port=3306;database=erpdatabase&quot; providerName=&quot;MySql.Data.MySqlClient&quot; /&gt;
    &lt;/connectionStrings&gt;
  &lt;/configuration&gt;
  </code></pre>