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
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<br />
SELECT DISTINCT Name<br />
FROM Table_A<br />
WHERE (Name NOT IN<br />
(SELECT DISTINCT Name<br />
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
Can you suggest me any method instead of using "dllimport and external"
Unless you want to write a C++/CLI implementation of your C++ function, or provide a C++/CLI version to act as a bridge, there is no other mechanism you can use (discounting you providing COM interfaces in your C++ code for your C# to hook into).
The PE header for .NET assemblies is different to the PE header for other libraries, which means that you can't add a none .NET assembly in as a reference.
You can just create a method that accepts a combobox as parameter. and then inside your method, just do the usual setting of the datasource to your combobox, just like what you are doing in your code. Im not sure though if your data source for your combo boxes will be the same. If it isn't, you might want to add parameters for your datasource, displaymember, and valuemember to your method.
I think that the answer that you are looking for is that you must
add anther class to your project, create a method within that class
using your curent code. You then re use this wherever you like by adding a reference to the new class
at the top of each form. have a look at what refactoring does.
Instances of the class can then be created and its methods etc can be used.
Make sense ?
is there any way how to prevent child process, created in C# code using Process class, to inharit parent process inharitable handles?
Some equivalent to API CreateProcess parameter bInheritHandles
Last Visit: 31-Dec-99 19:00 Last Update: 1-Dec-23 7:48