过滤数据表-@后缺少操作数

Question

我正在使用以下代码过滤数据表以显示包含我的电子邮件地址的元组。但我不断收到Missing Operand after @错误消息。

using (SqlConnection connection = new SqlConnection(conn))

{

    connection.Open();

    SqlCommand mycommand = new SqlCommand("select * from mytable",connection);

    // SqlDataReader dataReader = mycommand.ExecuteReader();

    DataTable dt = new DataTable();

    dt.Load(mycommand.ExecuteReader());

    string value = "[e-mail]";

    DataView dv = new DataView(dt);

    dv.RowFilter = "email = "+value;

    dataGridView1.DataSource = dv.ToTable();

    //  dataGridView1.DataSource = dt;

}

Answer 1

这里：string value = "[e-mail]";DataView dv = new DataView(dt);dv.RowFilter = "email = "+value;你正在做的是：DataView dv = new DataView(dt);dv.RowFilter = "email = [e-mail]";因此，您缺少包含文字字符串的撇号。你应该改用这个：string value = "'[e-mail]'";所以得到的过滤器是：dv.RowFilter = "email = '[e-mail]'";由于您可能从其他地方收到电子邮件（而不是硬编码在文件中），如果您使用的是 C# 6.0 或更高版本，则可以改为：string value = "[e-mail]";DataView dv = new DataView(dt);dv.RowFilter = $"email = '{value}'";

Answer 2

尝试这个。using (SqlConnection connection = new SqlConnection(conn)){  connection.Open();  var query = "select * from mytable WHERE email = '[e-mail]'";  SqlCommand mycommand = new SqlCommand(query,connection);  // SqlDataReader dataReader = mycommand.ExecuteReader();  DataTable dt = new DataTable();  dt.Load(mycommand.ExecuteReader());  DataView dv = new DataView(dt);  dataGridView1.DataSource = dv.ToTable();  // dataGridView1.DataSource = dt;}

Answer 3

为什么在从数据库中获取整个数据后进行过滤？只需在查询本身中过滤它：select * from mytable where email = '[e-mail]'

Answer 4

试试这个，让我知道它是否有效using (SqlConnection connection = new SqlConnection(conn)){  connection.Open();  SqlCommand mycommand = new SqlCommand("select * from mytable",connection);  // SqlDataReader dataReader = mycommand.ExecuteReader();  DataTable dt = new DataTable();  dt.Load(mycommand.ExecuteReader());  string value = "[e-mail]";  DataView dv = new DataView(dt);  dv.RowFilter = "email LIKE %'" + value + "'%";  dataGridView1.DataSource = dv.ToTable();  //  dataGridView1.DataSource = dt;}