title: how can i use the concat sql function in c#?
body: <p>i used this statement to combine 2 column values.</p>
  
  <pre><code>select concat(l_name," ",f_name) as "Full Name" from students;
  </code></pre>
  
  <p>i tried this statement in dreamcoder and it worked fine but when i used this statement in my c#, it gave me an error of no method overloading. it seems that the concat() is considered a method overload when i put it in c#. is there any possible way that i could use this statement in my c#?</p>
  
  <pre><code>public DataTable ExecuteQuery(string cmdtext)
  {
   DataTable table = new DataTable();
   var refDataAdapter = new MySqlDataAdapter(new MySqlCommand(cmdtext, CN));
   refDataAdapter.Fill(table);
   return table;
  }
  dataGridView1.DataSource = ExecuteQuery("select concat(l_name,", ",f_name) as FullName from students");
  </code></pre>
  
  <p>i used this code to fill show the table on my datagridview</p>