> What you need to do is stick with representing null in the > DataColumn by > using DbNull. Then you need to do a little extra tweaking > between marhsalled > calls. I assume you're taking the ItemArray and passing it's > values to the > COM object? If so you'll need to translate DbNull to null in > your local > array reference, make the COM call, translate null back to > DbNull before > returning the values by setting ItemArray array properties.
why i need something like VT_EMPTY within a datarow is that DBNull is a value like "Hello World"! when i translate the null back to DBNull the information if the value was filled is lost! setting the value empty is a marker for me to ignore these values when creating my update statement for the sql server. the old version of our programm was written in c++ and used safearrays to transfer the data. the new version is written in in c# and uses datasets to transfer data. thanks tobias You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.