语法错误：“学生”运算符后缺少操作数 [英] Syntax error: Missing operand after 'Student' operator

问题描述

这是我的代码：

private void btnSearch_Click(object sender, RoutedEventArgs e)
{

        using (SqlConnection sc = new SqlConnection(sConn))
        {
            sc.Open();


            string SearchFor = txtSearch.Text;



            using (SqlDataAdapter adapter = new SqlDataAdapter())
            {
                DataTable dt = new DataTable();
                grdData.ItemsSource = dt.DefaultView.RowFilter = string.Concat("SELECT * FROM Student WHERE Forename LIKE '%", SearchFor, "%'");
            }

运行代码时，我得到：

语法错误：'Student'运算符后缺少操作数。

"Syntax error: Missing operand after 'Student' operator."

我正在使用WPF ...我想要它，这样我就可以通过只输入他们的名字字母来搜索人们该怎么做？

I'm using WPF... I want it so I can search for people by just typing a letter of their name what can I do?

推荐答案

您需要先用一些数据填充 DataTable ，然后才能过滤结果

You need to fill your DataTable first with some data and then you can filter results

using (SqlConnection sc = new SqlConnection(sConn))
{
   sc.Open();
   using (SqlDataAdapter adapter = new SqlDataAdapter())
   {
       adapter.SelectCommand = new SqlCommand("SELECT * FROM Student", sc);
       var dataset = new DataSet();
       adapter.Fill(dataset);
       var dt = dataset.Tables[0];
       var dv = dt.DefaultView;
       dv.RowFilter = String.Concat("[Forename] LIKE '%", SearchFor, "%'");
       grdData.ItemsSource = dv;
   }
}

或在不带的SQL中进行过滤RowFilter

var cmd = new SqlCommand("SELECT * FROM Student WHERE Forename LIKE @forename", sc);
cmd.Parameters.AddWithValue("@forename", String.Concat("%", SearchFor, "%"));
adapter.SelectCommand = cmd;

这篇关于语法错误：“学生”运算符后缺少操作数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！