c# - 在c#.net中executenonquery并在datagridview中绑定(bind)它

Question

我是 c#.net 的初学者。我在将数据库(mysql)绑定(bind)到 datagridview 时遇到问题。该错误表明我的查询是错误的。当我在 MySQL 脚本上测试它时，我非常确定查询是正确的。顺便说一下，我尝试在 datagridview 中显示它。 dbMetName 是 datagridview。这是我的代码

private void Binding()
    {
        string connStr = "datasource=localhost;port=3306;username=root;password=root;";
        conn = new MySqlConnection(connStr);
        MySqlCommand command = conn.CreateCommand();
        try
        {
            string database = schemaForm.getData;
            dtable = new DataTable();
            bindingSource = new BindingSource(); ;

                conn.Open();
                command.CommandText = "SELECT Metabolite_Name" +
                                      "FROM " + database +
                                      ".Metabolites WHERE"+
                                      " MetaboliteID IN ('met1', 'met2');";
                command.ExecuteNonQuery();
                sqlData.SelectCommand = command;
                sqlData.Fill(dtable);
                bindingSource.DataSource = dtable;
                dbMetName.DataSource = dtable;
                dtable.Columns.Add("Metabolite Name");
                dbMetName.DataSource = dtable;
                conn.Close();        
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.Message);
        }
    }

从 getData 表单传递值

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace DynamicSimulator_v2
{
       public partial class SchemaName : Form
   {
      private static string data;
    public SchemaName()
    {
        InitializeComponent();
    }

    private void btnCancel_Click(object sender, EventArgs e)
    {
        this.Hide();
    }

    private void btnOK_Click(object sender, EventArgs e)
    {
        data=txtDB.Text;
        this.Hide();
    }

    public string getData
    {
        set
        {
            data = txtDB.Text;
        }
        get
        {
          return data;
          }
        }
      }
    }

Answer 1

Metabolite_Name 和 FROM 之间缺少空格:

"SELECT Metabolite_Name" +
"FROM " + database +