Hmm, hope this is not a stupid question.. but i've got lost (again)... :sign0161: i want to order number in sql database : numberid in row : (data) 1 2 3 4 5 6 ... and so on... 1500 cmd.CommandText = "select numberid from master order by numberid" ' and see the result : cmd.ExecuteTable("table1", rowstoload) but why in the table it becomes : 1 10 100 1000 1001 1002 1003 1004 1005 .... and so on... How can I fix this ? Thanks. PS: i need to use "order" command of sql function because i want to use this code: cmd.CommandText = "select numberid from master order by numberid" ' and see the result : cmd.ExecuteTable("table1", rowstoload) 'numberid has been loaded to tablecontrol (but not organized) ..... .... new control, lets say a button control : cmd.CommandText = "select data, numberid from master where numberid <= '" & table1.Cell("numberid", xxx) & "' cmd.ExecuteTable("table1", RowsToLoad) ' or >= from numberid (Yeah that's the code from dzt's project.) So it will chaos if the sorting of sql is not right, because the table control will be filled from sql. Sorry if the code / my explanation makes you a little bit confused, i haven't take a sleep for 3 days... Very curious and exciting with this project..