Click here to Skip to main content
15,922,427 members
Home / Discussions / C#
   

C#

 
AnswerRe: How do Compare two DataTable Pin
Heath Stewart8-Jul-04 4:03
protectorHeath Stewart8-Jul-04 4:03 
GeneralArticle submission question… Pin
Ray Cassick7-Jul-04 18:59
Ray Cassick7-Jul-04 18:59 
GeneralRe: Article submission question… Pin
Heath Stewart8-Jul-04 3:58
protectorHeath Stewart8-Jul-04 3:58 
GeneralC# class and COM+ issue Pin
hatim_ali7-Jul-04 18:57
hatim_ali7-Jul-04 18:57 
Generalabout software error detecting Pin
fu07-Jul-04 18:44
fu07-Jul-04 18:44 
QuestionEnvironment.SpecialFolder ?? Pin
azusakt7-Jul-04 17:45
azusakt7-Jul-04 17:45 
AnswerRe: Environment.SpecialFolder ?? Pin
Judah Gabriel Himango7-Jul-04 18:44
sponsorJudah Gabriel Himango7-Jul-04 18:44 
GeneralHOWTO: UserControl + Form Pin
Binoy Patel7-Jul-04 16:02
Binoy Patel7-Jul-04 16:02 
GeneralOutlook "like" Date Groupings Pin
pgraeve7-Jul-04 12:58
pgraeve7-Jul-04 12:58 
GeneralRe: Outlook "like" Date Groupings Pin
Werdna7-Jul-04 18:55
Werdna7-Jul-04 18:55 
GeneralRe: Outlook "like" Date Groupings Pin
pgraeve8-Jul-04 2:18
pgraeve8-Jul-04 2:18 
GeneralRe: Outlook "like" Date Groupings Pin
Gary Thom8-Jul-04 4:34
Gary Thom8-Jul-04 4:34 
Generalunderline Text in a Button Control Pin
isedf7-Jul-04 12:55
isedf7-Jul-04 12:55 
GeneralRe: underline Text in a Button Control Pin
Heath Stewart7-Jul-04 13:12
protectorHeath Stewart7-Jul-04 13:12 
Questionhow difficult does getting an instance by handle have to be? Pin
spazzman7-Jul-04 11:36
spazzman7-Jul-04 11:36 
AnswerRe: how difficult does getting an instance by handle have to be? Pin
Heath Stewart7-Jul-04 12:33
protectorHeath Stewart7-Jul-04 12:33 
AnswerRe: how difficult does getting an instance by handle have to be? Pin
MilesAhead11-Jul-04 16:44
MilesAhead11-Jul-04 16:44 
GeneralRe: how difficult does getting an instance by handle have to be? Pin
spazzman12-Jul-04 5:50
spazzman12-Jul-04 5:50 
GeneralRe: how difficult does getting an instance by handle have to be? Pin
MilesAhead12-Jul-04 6:55
MilesAhead12-Jul-04 6:55 
GeneralTreeView with ComboBoxes in TreeNodes Pin
theoutlander7-Jul-04 11:19
theoutlander7-Jul-04 11:19 
GeneralRe: TreeView with ComboBoxes in TreeNodes Pin
Heath Stewart7-Jul-04 12:38
protectorHeath Stewart7-Jul-04 12:38 
GeneralHowTo change color on statusbar Pin
QzRz7-Jul-04 9:54
QzRz7-Jul-04 9:54 
GeneralRe: HowTo change color on statusbar Pin
Heath Stewart7-Jul-04 12:50
protectorHeath Stewart7-Jul-04 12:50 
Generalproblem with SQLServer CE Pin
JulienR7-Jul-04 8:51
JulienR7-Jul-04 8:51 
GeneralRe: problem with SQLServer CE Pin
Heath Stewart7-Jul-04 12:56
protectorHeath Stewart7-Jul-04 12:56 
FYI, a DataAdapter derivative like SqlCeDataAdapter will open the close the connection itself. Logically, there's no way to query for data unless it connects to the database. You should not open the connection yourself.

If you read the documentation for the SqlCeConnection class in the .NET Framework SDK, you might notice the following:
Although SQL Server CE only supports one connection at a time, multiple commands can share the same connection. This means that it is possible to have multiple instances of SqlCeDataReader open on the same connection. This behavior differs from that of System.Data.SqlClient.
Since you're using two assemblies, you do have the option of exposing the connection. Since both the MC++ and C# assemblies are .NET assemblies (both compiled to IL, although a mixed mode MC++ assembly may also contain native instructions), you can reference one from another. So perhaps you could expose the SqlCeConnection from the MC++ assembly and the C# assembly could use that. You could - through mutexes or some other locking mechanism - make sure that the SqlCeConnection in one assembly is closed and disposed (always call Dispose on IDisposable implementations when you're finished with them) before attempting to make another connection (perhaps using a broker or provider pattern).

 

Microsoft MVP, Visual C#
My Articles

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.