minnie mouse wrote: I want to do this in C# Then you would probably get a better response in the C# forum. However, the control you need will most likely be a ListView[^].

This query does work when run as a sql command against a 2005 express database, changing to nvarchar has removed the error due to the type incompatability, thanks. However when I ran the command from the app it had legal syntax but no affect ? So i pasted it into the sql pane and intllisense altered the statement to this INSERT INTO Table_C (Name) SELECT DISTINCT Name FROM Table_A WHERE (Name NOT IN (SELECT DISTINCT Name FROM Table_B AS Table_B_1)) This SQL command now works, i will have to do some homework on why that change is required for SQL CE 3.5 and not in SQL 2005 express :confused:

Thanks for that, i will investigate the message queue alternative i think. I had thought about using an XML file but it seems like that could introduce possible problems. It is reliability i am after.

'setview' function may can help you, but i think it's impossible. 2) try to use win32 API to find the control you want to highlight, but i think it's impossible. adobe Reader activeX control ver 7.0 never support that Interface functions. April Comm100 - Leading Live Chat Software Provider

Take a look at the Except operator. Deja View - the feeling that you've seen this post before. My blog | My articles

Thanks for this help, please see Christians comments Much clearer now.:)

you can use grid[row,col] count the sum if ur are using dataTable as datatable then if sum is zere delet column form dataTable, sikandar

minnie mouse wrote: so the conventional approach of creating a database , data source, tables, table adaptors, and so on in the IDE doesnt work as there is no data to begin with. Don't use the IDE, it is bad practice anyway. You should create a separate class for your data interaction (or multiple classes if you want to split the data interaction up into logical grouping - you can put the common stuff in a base class and have all your data access classes inherit from it). If you don't know how to write data access code already have a look at what the IDE is doing for you then copy and modify it for your own uses. Scottish Developers events: * .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog

Thanks, " Persistance alone is omnipotent" (Calvin Cooolidge):cool: