Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting proper type for Text and NVarChar
Message
From
04/04/2011 21:32:57
 
 
To
All
General information
Forum:
ASP.NET
Category:
Other
Title:
Getting proper type for Text and NVarChar
Environment versions
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01506081
Message ID:
01506081
Views:
106
If I initialize a SQL parameter such as this:
loSqlParameter.SqlDbType = SqlDbType.Text
...and use this to get its type:
loDataParameterSQLClient.DbType.ToString
...I guess AnsiString.

If I initialize a SQL parameter such as this:
loSqlParameter.SqlDbType = SqlDbType.NVarChar
...and do the same, I guess String.

How can I get the SqlDbType to recognize that this is a Text or NVarChar field? Isn't SqlDbType.Text and SqlDbType.NVarChar suppose to define it as is?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Next
Reply
Map
View

Click here to load this message in the networking platform