Filter Datatable by providing Scientific Notation Formatted Value

More over, i have datatable also in my application but with the origanl values...
regares

Dear,
I have data sample like following
id,Name,Store,Distance
4,David,HKB,1056
6,Rock,hkb,95182.589
7,John,Store1,125.193
Suppose this data is stored in SQL with table name store..
Now, i bind this data with my grid in my application, and user want to view Distance in scientific notation, suppose with 2 decimal places.
Now when i will convert or when my grid will show this data like distance in scientific notation then suppose value 1056, will be '1.06E+003'
Now if i want to filter my values on the basis of my distance, suppose user selects '1.06E+003', then this value will not match value in database.
One Proplem is that when user selects value for filter, i d'nt have actul value when i boud in grid, i just have this value in string,
Now here is the problem, what should do to just match the value with database, one solution was that i select valuse from database in scientific notation and then copare it, but i d'nt know how to select values in scientific notatin with formating like decimal places etc..
Thanks in advace for my help
regards..
 

Hey Can you Provide Me Information

What column You are having in Your Datatable ?

and Also Provide Sample data you are having in that Datatable


and How you want to search .

I can help you if you provide some more info :)