title: Help: MySQL adapter.fill(dataset) Error
body: <p>I'm connecting to a MySQL database using the MySqlClient class.  When I try to fill a fill a Data List with the Data Set I get an error:</p>
  
  <p><strong>#42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax</strong></p>
  
  <p>Heres the code I have in VB.net to fill the data list.  </p>
  
  <pre><code> Dim strConn As String = "server=name;uid=un;pwd=pass;database=db"
              Dim myConnection As New MySqlConnection(strConn)
              Dim strSQL As String = "SELECT * FROM Articles = "
              Dim myDataAdapter As New MySqlDataAdapter(strSQL, myConnection)
  
              Dim ds As New DataSet()
  
              myConnection.Open()
              myDataAdapter.Fill(ds, "Articles")
              MyDataList.DataSource = ds
  
              myconnection.close()
  </code></pre>
  
  <p>Heres the Code for the DataList Control</p>
  
  <pre><code>&lt;ASP:DataList id="MyDataList" runat="server"&gt;
        &lt;ItemTemplate&gt;
          Title:
           &lt;%# DataBinder.Eval(Container.DataItem, "title")%&gt; 
        &lt;br&gt;
        &lt;b&gt;Author: &lt;/b&gt;
        &lt;%#DataBinder.Eval(Container.DataItem, "Author")%&gt;&lt;br&gt;
        &lt;b&gt;PubDate: &lt;/b&gt;
        &lt;%#DataBinder.Eval(Container.DataItem, "PubDate")%&gt;&lt;br&gt;
          &lt;p&gt;
  
        &lt;/ItemTemplate&gt;
     &lt;/ASP:DataList&gt;
  </code></pre>
  
  <p>The connection works fine, and I am able to grab values; but I cannot fill this Data List.</p>