语法错误:“学生”运算符后缺少操作数 [英] 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屋!
查看全文