我正在使用以下代碼過濾數據表以顯示包含我的電子郵件地址的元組。但我不斷收到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 = "[email protected]"; DataView dv = new DataView(dt); dv.RowFilter = "email = "+value; dataGridView1.DataSource = dv.ToTable(); // dataGridView1.DataSource = dt;}
4 回答
鳳凰求蠱
TA貢獻1825條經驗 獲得超4個贊
這里：
string value = "[email protected]";
DataView dv = new DataView(dt);
dv.RowFilter = "email = "+value;
你正在做的是：
DataView dv = new DataView(dt);
dv.RowFilter = "email = [email protected]";
因此，您缺少包含文字字符串的撇號。你應該改用這個：
string value = "'[email protected]'";
所以得到的過濾器是：
dv.RowFilter = "email = '[email protected]'";
由于您可能從其他地方收到電子郵件（而不是硬編碼在文件中），如果您使用的是 C# 6.0 或更高版本，則可以改為：
string value = "[email protected]";
DataView dv = new DataView(dt);
dv.RowFilter = $"email = '{value}'";
桃花長相依
TA貢獻1860條經驗 獲得超8個贊
嘗試這個。
using (SqlConnection connection = new SqlConnection(conn))
{
connection.Open();
var query = "select * from mytable WHERE email = '[email protected]'";
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;
}
冉冉說
TA貢獻1877條經驗 獲得超1個贊
森欄
TA貢獻1810條經驗 獲得超5個贊
試試這個，讓我知道它是否有效
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 = "[email protected]";
DataView dv = new DataView(dt);
dv.RowFilter = "email LIKE %'" + value + "'%";
dataGridView1.DataSource = dv.ToTable();
// dataGridView1.DataSource = dt;
}
- 4 回答
- 0 關注
- 167 瀏覽
添加回答
舉報
0/150
提交
取消