How To Use N Syntax For Unicode Parameters

Hi all,





I had two Nvarchar(255) columns & retreive it like this





DIM CN1 AS SQLCONNECTION


DIM DR1 AS SQLDATAADAPTER


DIM DTABLE AS DATATABLE


DIM DTSET AS DATASET





DTSET=NEW DATASET()


DR1=NEW SQLDATAADAPTER("SP_PRO1",CN1)


DR1.SELECTCOMMAND.COMMANDTYPE=COMMANDTYPE.STOREDPROCEDURE


DR1.SELECTCOMMAND.PARAMETERS.ADD("@TYPE1", REQUEST.QUERYSTRING("PID"))


DR1.SELECTCOMMAND.PARAMETERS.ADD("@TYPE1", REQUEST.QUERYSTRING("UID"))


DR1.FILL(DTSET,CINT(INTCURRINDEX.TEXT),CINT (INTPAGESIZE.TEXT),"SP_PRO1")


DL1.DATASOURCE=DTSET.TABLES(0).DEFAULTVIEW


DL1.DATABIND()


CN1.CLOSE()


END SUB





How to insert "N" National Code to parameter? I try it N"@TYPE1" or "N@TYPE1" with failed. Any ideas or advise? Thanks a lot.





Aris