Error In Search Of Mobile No From Data Gird

Rizwan Ahmed

I want to search mobile no from Grid with selection of ComboBox. Search bar search names but when i code for mobile and cnic this error appeared, error and code as under; (using C# with Access2016 database)

System.Data.EvaluateException: 'Cannot perform 'Like' operation on System.Double and System.String.'

private void txtSearchBar_TextChanged(object sender, EventArgs e)
{
if (comboxSearch.Text == "Mobile No")
{
DataView dv = dt.DefaultView;
dv.RowFilter = "MobileNo LIKE '%" + txtSrchBar.Text.ToString() + "%' ";
}
}

9 Replies

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

Amit Gupta7y ago
Accepted answer
dv.RowFilter = "Convert(System.String, MobileNo) LIKE '%" + txtSrchBar.Text.ToString() + "%' ";

Update:
Proper filter should be like this
dv.RowFilter = "Convert(MobileNo, 'System.String') LIKE '%" + txtSrchBar.Text.ToString() + "%' ";

Try abive code and let me know, if it works or have a look to this link
https://stackoverflow.com/questions/34676878/filtering-datatable-number-column/34677049#34677049
Rizwan Ahmed7y ago
sorry Amit Sir i tried your code but it didn't work but i forget to try your link but after your this reply i tried your link it works thnx Amit sir
Amit Gupta7y ago
@Rizwan, Have you tried my updated answer, there is no matter what's the datatype coming from your database, to use like operator, column should be string type so we have converted to string type, I have used this type of features plenty times.
Rizwan Ahmed7y ago
MobileNo is Double in Database and if i retrieve than which dtype i use to use LIKE function to my textbox
Rizwan Ahmed7y ago
how can i check which is the data type of my text to match sir Luxmindhar?
Laxmidhar Sahoo7y ago
after retrive the data from the database into ds .Define a datatable woth the same fields that matchs to ds table .But mobilno should be text type .Data datable assign to grid and convert to DataView .So you can use Like operator
Rizwan Ahmed7y ago
Laxmidhar Sahoo it's in Double.

Amit Gupta i tried it but now this error comes, System.Data.EvaluateException: 'Cannot find column [System.String].' and indicate to this code dv.RowFilter = "Convert(System.String, MobileNo) LIKE '%" + txtSrchBar.Text.ToString() + "%' ";
Sanwar Ranwa7y ago
Hello

Please check these Links

https://www.c-sharpcorner.com/UploadFile/0c1bb2/searching-records-from-database-and-display-in-gridview-usin/

https://www.codeproject.com/Questions/74383/System-Data-EvaluateException-Cannot-find-column-B
Laxmidhar Sahoo7y ago
what is the data type of MobileNo

Error In Search Of Mobile No From Data Gird

Amit Gupta i tried it but now this error comes, System.Data.EvaluateException: 'Cannot find column [System.String].' and indicate to this code dv.RowFilter = "Convert(System.String, MobileNo) LIKE '%" + txtSrchBar.Text.ToString() + "%' ";