D
darrel
I'm using parameterized sql for my Db updates and typically use something
like this:
objCommand.Parameters.Add("@pageID",
System.Data.OleDb.OleDbType.numeric).Value = 24
However, I now need to add a string to a 'text' field in MsSQL. There isn't
a System.data.oledbtype.text option.
Is System.Data.OleDb.OleDbType.LongVarChar proper? Another option? BSTR?
-Darrel
like this:
objCommand.Parameters.Add("@pageID",
System.Data.OleDb.OleDbType.numeric).Value = 24
However, I now need to add a string to a 'text' field in MsSQL. There isn't
a System.data.oledbtype.text option.
Is System.Data.OleDb.OleDbType.LongVarChar proper? Another option? BSTR?
-Darrel