How to make upper all data in datatable?
-
Hello experts, I'm making a matching program that will match the customer name. For that I have a datatable with all customer names. I want to make them upper before matching how i can do that...? I'm using foundCustomerRows = Datatable.Select("CustomerFullName = '" + strCustomerToPost.ToString().Toupper() + "'"); Is there any property to make Select ( ucase(CustomerFullName) =....?:confused: Or there is any other way to make all the column upper in a data table when you match the data...? Please help...
Regards Pankaj Joshi If you want to shape your dreams into reality, please wake-up...
-
Hello experts, I'm making a matching program that will match the customer name. For that I have a datatable with all customer names. I want to make them upper before matching how i can do that...? I'm using foundCustomerRows = Datatable.Select("CustomerFullName = '" + strCustomerToPost.ToString().Toupper() + "'"); Is there any property to make Select ( ucase(CustomerFullName) =....?:confused: Or there is any other way to make all the column upper in a data table when you match the data...? Please help...
Regards Pankaj Joshi If you want to shape your dreams into reality, please wake-up...
-
Hello experts, I'm making a matching program that will match the customer name. For that I have a datatable with all customer names. I want to make them upper before matching how i can do that...? I'm using foundCustomerRows = Datatable.Select("CustomerFullName = '" + strCustomerToPost.ToString().Toupper() + "'"); Is there any property to make Select ( ucase(CustomerFullName) =....?:confused: Or there is any other way to make all the column upper in a data table when you match the data...? Please help...
Regards Pankaj Joshi If you want to shape your dreams into reality, please wake-up...
Use the database for that query and not the dataset. Some databases have the option to enable case sensitive or insensitive searches. Also the ability to do the choice in the where clause.
Need a C# Consultant? I'm available.
Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway