[原创]C# Access 模糊查询SQL语句

/// <summary>
/// 创建一个OleDbConnection连接.
/// </summary>
/// <returns></returns>
private System.Data.OleDb.OleDbConnection CreateConnection()
{
   string connStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + DBPath;
   OleDbConnection conn = new OleDbConnection(connStr);
   if (conn.State != ConnectionState.Connecting) conn.Open();
   return conn;
}

//搜索用户表
public DataTable Search(string userID, string userName)
{
   string where = " 1=1 ";
   if (userID.Trim() != "")
   where = where + " and [UserID]=’" + userID + "’";
   if (userName.Trim() != "")
   where = where + " and [UserName] like ’%" + userName + "%’"; //模糊查询
   
   string sql = "select * from t_User where " + where;
   
   return DataProvider.Instance.GetDataTable(sql);
}