SQL Everywhere SLSErver To SQLEv Without SSI && IIS

Due to client requirements i have found it necessary to write an application that moves data from SQL Server to SQLEv

To do this I open the SQLServer table and using a FOREACH Statement track through the table

I then cast each of the fields I require into a variable

Each record then calls and INSERT INTO statement to insert the data into SQLEV

One serious problem is how do I get round NULLs

ie if contents = (string)ditem["CONTENTS"]; returns a NULL it crashes

So I want something like

IF ditem["CONTENTS"] = NULL

contents = ""

else

contents = (string)ditem["CONTENTS"]



It is very slow the insert statement takes about .7 of a second (although it does seem to speed up)

I enclose a bit of the code

Get the required data

contents = (string)ditem["CONTENTS"];

metrics = (string)ditem["METRICS"];

pickface = (string)ditem["PICKFACE"];

profile = (string)ditem["PROFILE"];

stocktake = (DateTime)ditem["STOCKTAKE"]; //&& ditem["STOCKTAKE"] is DBNull;



// now update the database

this.iTEMTableAdapter1.InsertQuery(

isbom, vendno, item, posloc, desc,

longdesc,size,style,colour,classname,

upccode,upcinner,upcouter,upccase,cuscode ,status,

donhand,dphysical,dnumeric1,dnumeric2,

logic3,logic1,obselete,donorder,

contents,metrics,pickface,profile);

Any ideas please

Richard