//按钮点击事件
private void Btn_Search_Click(object sender, EventArgs e)
{
//获取编辑框的值
string text = this.textEdit1.Text; ColumnView view = (ColumnView)UserManagementGrid.FocusedView;
GridColumn column = null; //判断是否为空
if (!text.Equals(""))
{
//判断首个字符是否是英文
if ((text[] > 'a' && text[] < 'z') || (text[] > 'A' && text[] < 'Z'))
{
//英文(UserName为数据库里面的列名,TrueName同理)
column = view.Columns["UserName"];
}
else
{
//不是英文
column = view.Columns["TrueName"];
}
}
else
{
ShowInfo("请输入用户名或姓名!");
} if (column != null)
{
int rhFound = ;
//从第0行开始查询,查询的列,匹配列中的值
rhFound = view.LocateByDisplayText(, column, text); //如果行值正常,即条件满足，存在
if (rhFound != DevExpress.XtraGrid.GridControl.InvalidRowHandle)
{
view.FocusedRowHandle = rhFound;
view.FocusedColumn = column;
view.SelectRow(rhFound);
}
else
{
ShowInfo("无此用户名或姓名!");
}
} } /// <summary>
/// 行风格设置
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void UserManagementView_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
//如果行不是焦点行，则背景色为白色
if (e.RowHandle != UserManagementView.FocusedRowHandle)
{
e.Appearance.BackColor = Color.White;
} }
方法二：
通过特定列的值搜索
public List<Users> GetUsersByShowText(string text)
{
return _db.Users.Where(p => p.UName.Contains(text) || p.TrueName.Contains(text)).ToList();
}