try this as a simpler solution, just keep adding sets of 3 #s string.Format("{0:### ### ###.00}", 30000000); Never underestimate the power of human stupidity RAH

i did searched but i got results that were irrelevant. thanks anyway

That's odd... Check that you don't have another DSN (system or user) with the same name. If not helpful: - delete the DSN - check from the registry that it's gone (HKEY_CURRENT_USER\Software\ODBC\ODBC.INI or HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI) - create it again (use a different name just in case) - again verify from registry that it's configured as it should be.

Deques wrote: the european computers have comma set in the regional settings. so this could be problematic unless i change the decimal to a dot. The only way this is going to be a problem is if you are injecting values in to the SQL string. If you use parameters this is not an issue and nor does it blow a massive security hole in your application. Please read this article on SQL Injection Attacks and how to prevent them[^] Upcoming FREE developer events: * Developer Day Scotland Recent blog posts: * Different ways to add point data in SQL Server 2008 * Spatial References in SQL Server 2008 My website |

I believe you need to join the table to a subset of itself. You create a subquery that gives you the values of project and the highest col1 and attribute that to a temptable. You then join you orignal table to your temp table on the values of col1. This should do the trick! SELECT PT.* FROM out_pumptable PT join (select project, max(col1) as MaxVal from out_pumptable group by project) TEMPTABLE1 on TEMPTABLE1.MaxVal = PT.col1

The index of the column you clicked is part of the ColumnClickEventArgs you receive when the ColumnClick event is fired. Regards, mav -- Black holes are the places where God divided by 0...

Welcome. Glad to hear that it helped All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions

its nice but i prefer to use if(f.Name == "RibbonForm1") and not if(f.Text == "RibbonForm1") because he can change the name dynamically respect. spaps

Depenteds Where ( What kind of control are u using? ) //I have not worked with DataGrid, //But i think i a bit simliar to DataGridView In DataGridView it Works fine :) Have Fun Never forget it

ok, I understand now. thanks for the answer

Well that's something I haven't figured out yet. If you find the answer, please let me know. Thanks, Talal -- If this is a post that has been helpful to you, please vote for it. Thank you! "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." --Rich Cook

thanks, this is a good article edit: i tried this on a windows mobile and it seems not be working :( -- modified at 5:11 Tuesday 24th April, 2007

thanks for your answer, it works