c# - 按用户输入过滤获取错误消息无法获取表 0

Question

我已经按照此处发布的教程编写了代码 http://csharp.net-informations.com/datagridview/csharp-datagridview-filter.htm

但是我一直收到错误“找不到表 0”，我尝试了几种方法但都没有用

我已经在我的表单加载中发布了代码和启动该过程的按钮

string connectionString = "server=localhost;user id=root;database=epas=";
string sql = "SELECT * FROM pricing sterling";
SqlConnection con = new SqlConnection(connectionString);
SqlDataAdapter dataadapter = new SqlDataAdapter(sql, con);
con.Open();
dataadapter.Fill(ds, "pricing table");
con.Close();

dataGridView1.DataSource = ds.Tables[0];

还有按钮

DataView dv;
dv = new DataView(ds.Tables[0], "ID = '21' ", "type Desc", DataViewRowState.CurrentRows);
dataGridView1.DataSource = dv;

Answer 1

去掉数据表名中的空格

dataadapter.Fill(ds, "pricingtable");