Filter Datatable by providing Scientific Notation Formatted Value

Question

Hello Guys...
I have a datatable, having different types of columns.
I want to filter values in datatable,
Suppose I have values in my application displayed in Scientific notation, now in datatable i have values in normal Numeric format e.g Integer,Float, currency etc,
I want to filter datatble by providing value like -1.06E+003, with two decimal places, but actully in datatable values are -1056,
Can any one Explain me how can i get filtered values providing scientific notation in Filter...
Thanks in advance

regards..

shakeel ahmad · Answer

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

shakeel ahmad · Answer

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..

Kirtan Patel · Answer

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 :)

Filter Datatable by providing Scientific Notation Formatted Value

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)