When search on column have numbers and character not search for text ?

I work on asp.net dev express gridview . I face issue when search on gridview column department code

it accept filter by numbers but text not accept filter .

as Example

column Depart code have value 101HRE

if i search for 101 give me result value 101HRE

if i search for HRE not give me result 101HRE but give me empty result

why it accept search by numbers and not accept search by text this is my question

full code details

<%@ Page Title="" Language="C#" MasterPageFile="~/Main.Master" AutoEventWireup="true" CodeBehind="SickLeaveDashboard.aspx.cs" Inherits="UCHRADMIN.SickLeaveDashboard" %>

<%@ Register Assembly="DevExpress.Web.v19.1, Version=19.1.16.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" Namespace="DevExpress.Web" TagPrefix="dx" %>

It seems you're facing an issue with the DevExpress GridView's filtering mechanism, specifically when trying to filter the "Dept Code" column. The behavior you described, where numeric filters work but text filters don't, is indeed puzzling.

From the code you've provided, the "Dept Code" column is defined as a text column (GridViewDataTextColumn). This should allow both numeric and text-based filtering. One potential issue could be related to the data type of the underlying data source. If the data source treats "Dept Code" as a numeric field, it might explain the behavior you're seeing. However, from the SQL query you provided, it seems "Dept Code" is being cast to a varchar, so this might not be the issue.

Another thing to consider is the version of DevExpress you're using. There might have been bugs in older versions that could cause such behavior. It might be worth checking if there are updates available for your version of DevExpress or if there are known issues related to this.

Lastly, if you're still facing this issue and can't find a solution, it might be beneficial to consult with a team specialized in app development in New York. They often have experts who've dealt with similar issues in the past and can provide a quick resolution. They might also offer insights into best practices when working with DevExpress controls and ASP.NET in general.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Alan A3y ago
It seems you're facing an issue with the DevExpress GridView's filtering mechanism, specifically when trying to filter the "Dept Code" column. The behavior you described, where numeric filters work but text filters don't, is indeed puzzling.

From the code you've provided, the "Dept Code" column is defined as a text column (GridViewDataTextColumn). This should allow both numeric and text-based filtering. One potential issue could be related to the data type of the underlying data source. If the data source treats "Dept Code" as a numeric field, it might explain the behavior you're seeing. However, from the SQL query you provided, it seems "Dept Code" is being cast to a varchar, so this might not be the issue.

Another thing to consider is the version of DevExpress you're using. There might have been bugs in older versions that could cause such behavior. It might be worth checking if there are updates available for your version of DevExpress or if there are known issues related to this.

Lastly, if you're still facing this issue and can't find a solution, it might be beneficial to consult with a team specialized in app development in New York. They often have experts who've dealt with similar issues in the past and can provide a quick resolution. They might also offer insights into best practices when working with DevExpress controls and ASP.NET in general.