thank you. I know the command. I just want these 3 columns.

Of course there's an error...your select command is not written correctly. This is what it looks like to SQL: SELECT [ID]+" "+[Magasin]+" "+ [qtyonhand] AS IMQ from stocks where ID like %@txt% You need to look at a SQL reference and see how to write a proper SQL Select statement. Why did you put in +\" \"? Where in the world did you see that. And please, start using proper naming conventions. When you add a control, change it's name to reflect what it is and what it holds. Take a look here: Naming convention[^]

Most probably the table opened from visual studio is just a local copy of the database file. Your operation is made on the smart device simulator, on that database. You can download the file from the smart device and check the row is inserted, or you can execute a select command on the device to check the row count. I have no smart signature yet...

thank you for your help, But i am working on a mobile application and it is not a web application. I found finallay the solution for the problem. It was very simple: add a parameter to the constructor of the form and call it with this parameter.

thanks to tunisien86 that gave an idea to solve the problem this is the link you can see it if you have problems. thank you. http://social.msdn.microsoft.com/Forums/en-US/vssmartdevicesvbcs/thread/0f32993e-5b16-43b4-b7b6-09a3f66eb2f2/