110,571
社区成员
发帖
与我相关
我的任务
分享
public IEnumerable<Model_Shortcuts> ListWhereLIKE_ExplainContent(string pWhereExplainORContent)
{
List<Model_Shortcuts> list = new List<Model_Shortcuts>();
this.DataGridViewRowsIndex = 0;
string strsql = @"SELECT Shortcuts_ID,Code,Explain,Content,Images,Shortcuts_MenuTitleForeignKey,Shortcuts_CategoryForeignKey FROM Shortcuts
WHERE Explain LIKE ? OR Content LIKE ?";
OleDbParameter[] parms = { new OleDbParameter("?",OleDbType.LongVarWChar),new OleDbParameter("?",OleDbType.LongVarWChar) };
parms[0].Value = "'*"+pWhereExplainORContent+"*'";
parms[1].Value = "'*"+pWhereExplainORContent+"*'";
DataTable dt = db.ExecuteDataTable(strsql, parms);
foreach (DataRow row in dt.Rows) { list.Add(ToModel(row)); }
return list;
}
public DataTable ExecuteDataTable(string cmdText, params OleDbParameter[] paras)
{
using (OleDbConnection con = new OleDbConnection(strcon))
{
con.Open();
using (OleDbCommand cmd = con.CreateCommand())
{
cmd.CommandText = cmdText;
if (paras != null)
{
cmd.Parameters.AddRange(paras);
}
DataTable dt = new DataTable();
OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
adapter.Fill(dt);
cmd.Parameters.Clear();
return dt;
}
}
}
//奇怪的是 我用纯字符串拼接 也不行!!!!!!!
string strsql = @"SELECT Shortcuts_ID,Code,Explain,Content,Images,Shortcuts_MenuTitleForeignKey,Shortcuts_CategoryForeignKey FROM Shortcuts WHERE Explain LIKE '*"+pWhereExplainORContent+"*' OR Content LIKE '*"+pWhereExplainORContent+"*'";
DataTable dt = db.ExecuteDataTable(strsql, null);
foreach (DataRow row in dt.Rows) { list.Add(ToModel(row)); }
return list;