Click here to Skip to main content
15,888,461 members
Home / Discussions / C#
   

C#

 
GeneralRe: [MOSS 2007 C# WebPart] Timer/UpdatePanel, help please... Pin
Not Active1-Aug-10 16:35
mentorNot Active1-Aug-10 16:35 
GeneralRe: [MOSS 2007 C# WebPart] Timer/UpdatePanel, help please... [modified] Pin
crosslink062-Aug-10 23:45
crosslink062-Aug-10 23:45 
GeneralRe: [MOSS 2007 C# WebPart] Timer/UpdatePanel, help please... Pin
crosslink065-Aug-10 7:47
crosslink065-Aug-10 7:47 
QuestionSQL Query On DataTable Pin
cdpace30-Jul-10 4:07
cdpace30-Jul-10 4:07 
AnswerRe: SQL Query On DataTable Pin
Yusuf30-Jul-10 5:43
Yusuf30-Jul-10 5:43 
QuestionProgrammatically set the admin only permission to event viewer file in window 7 Pin
vinaykhin30-Jul-10 1:29
vinaykhin30-Jul-10 1:29 
AnswerRe: Programmatically set the admin only permission to event viewer file in window 7 Pin
vinaykhin17-Aug-10 21:59
vinaykhin17-Aug-10 21:59 
QuestionCOM server containing bulk insert impl called from Matlab Pin
devvvy29-Jul-10 23:51
devvvy29-Jul-10 23:51 
hello

I need to provide facility for Matlab to do bulk insert to SQL. Matlab provides ways to load .NET assembly and call .NET methods:
Assembly reference: http://www.mathworks.com/access/helpdesk/help/techdoc/ref/net.addassembly.html
Method calls: http://www.mathworks.com/access/helpdesk/help/techdoc/matlab_external/brpb58s-1.html#brpca5n-1
However, we can't pass "Cell Array":

Example:
 <br />
% 2 Dimensional array of numbers<br />
a=[1 2 3; 3 4 5; 6 7 8]<br />
aa=[1.1 2.2 3.3; 4.4 5.5 6.6; 7.7 8.8 9.9]<br />
% Single dimension string array (2D not permitted)<br />
b={'aaa0'; 'bbb0'; 'ccc0'}<br />
bb={'aaa0','aaa1'; 'bbb0', 'bbb1'; 'ccc0', 'ccc1'}<br />
<br />
c={'20100701' 1.11 2.22; '20100702' 3.33 4.44; '20100703' 5.55 6.66;}<br />
<br />
"c" above is cellarray 


Now, my only option is to wrap bulk insert logic in ATL COM server, and call from Matlab as such:

dbServer = actxserver('MyDBComServer');

The first article below shows how to build a simple ATL server in C++ but:
PROBLEM 1: sample shows only passing simple type such as string/BSTR - I need to pass a Matlab CellArray across (For this problem... I don't have much clue how CellArray is represented in memory as thereby passed across Matlab/COM/.NET borders)
PROBLEM 2: I don't have access to .NET System.Data.SqlClient.SqlBulkCopy (For this problem can I packaged ATL done by C#? From Visual Studio 2008 \ New Project, I can find "ATL Projects" only under VC++. Is my option a COM server without ATL as indicated in Third Reference below? I am inheriting an old VB.NET COM project but having problem getting it registered, but it must be possible)
PROBLEM 3: Windows 2003 64 bit - any deadend you know?


http://digital-clipart.de/KB/COM/SimpleCOM.aspx[^]
1..2..3 ways of integrating MATLAB with the .NET[^]

http://msdn.microsoft.com/en-us/library/aa645712(v=VS.71).aspx[^]
dev

QuestionReflection to load an assembly application wide (like referencing it) Pin
hoernchenmeister29-Jul-10 23:38
hoernchenmeister29-Jul-10 23:38 
AnswerRe: Reflection to load an assembly application wide (like referencing it) Pin
PIEBALDconsult30-Jul-10 6:00
mvePIEBALDconsult30-Jul-10 6:00 
GeneralRe: Reflection to load an assembly application wide (like referencing it) Pin
hoernchenmeister1-Aug-10 20:42
hoernchenmeister1-Aug-10 20:42 
GeneralRe: Reflection to load an assembly application wide (like referencing it) Pin
PIEBALDconsult2-Aug-10 2:58
mvePIEBALDconsult2-Aug-10 2:58 
GeneralRe: Reflection to load an assembly application wide (like referencing it) Pin
hoernchenmeister2-Aug-10 3:42
hoernchenmeister2-Aug-10 3:42 
GeneralRe: Reflection to load an assembly application wide (like referencing it) Pin
PIEBALDconsult2-Aug-10 3:54
mvePIEBALDconsult2-Aug-10 3:54 
GeneralRe: Reflection to load an assembly application wide (like referencing it) Pin
hoernchenmeister2-Aug-10 4:59
hoernchenmeister2-Aug-10 4:59 
GeneralRe: Reflection to load an assembly application wide (like referencing it) Pin
PIEBALDconsult2-Aug-10 12:28
mvePIEBALDconsult2-Aug-10 12:28 
GeneralRe: Reflection to load an assembly application wide (like referencing it) Pin
hoernchenmeister2-Aug-10 20:29
hoernchenmeister2-Aug-10 20:29 
AnswerRe: Reflection to load an assembly application wide (like referencing it) Pin
Bernhard Hiller1-Aug-10 22:01
Bernhard Hiller1-Aug-10 22:01 
GeneralRe: Reflection to load an assembly application wide (like referencing it) Pin
hoernchenmeister2-Aug-10 1:20
hoernchenmeister2-Aug-10 1:20 
QuestionUpperBound of Dynamic array Pin
Enobong Adahada29-Jul-10 22:36
Enobong Adahada29-Jul-10 22:36 
AnswerRe: UpperBound of Dynamic array Pin
Sathesh Sakthivel29-Jul-10 23:35
Sathesh Sakthivel29-Jul-10 23:35 
AnswerRe: UpperBound of Dynamic array Pin
OriginalGriff29-Jul-10 23:43
mveOriginalGriff29-Jul-10 23:43 
GeneralRe: UpperBound of Dynamic array Pin
riced30-Jul-10 0:29
riced30-Jul-10 0:29 
GeneralRe: UpperBound of Dynamic array Pin
OriginalGriff30-Jul-10 0:33
mveOriginalGriff30-Jul-10 0:33 
GeneralRe: UpperBound of Dynamic array Pin
Keith Barrow30-Jul-10 0:49
professionalKeith Barrow30-Jul-10 0:49 

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.