• You connect to the Microsoft SQL Server database by using Visual Studio .NET Server Explorer and then you drag a database table that contains columns where the data type is text or ntext to the form designer.
• You connect to the SQL Server database by using Visual Studio .NET Server Explorer and then you drag a stored procedure that contains parameters where the data type is text or ntext to the form designer.

Back to the top

Steps to Reproduce the Behavior

1. Start SQL Query Analyzer (or SQL Server Enterprise Manager), and then create a new stored procedure in the SQL Northwind sample database as follows:

   USE Northwind
   Go
   CREATE proc TestProc
   @ntextParam ntext,
   @textParam text
   as
   return 1
   Go
   

2. Start Microsoft Visual Studio .NET.
3. On the File menu, point to New, and then click Project.
4. Click Visual Basic Projects or Visual C# Projects under Project Types, and then click Windows Application under Templates. By default, Form1 is created.
5. On the View menu, click Server Explorer.
6. In Server Explorer, right-click Data Connections, and then click Add Connection.
7. In the Data Link Properties dialog box, type your local SQL Server name in the Select or enter a server name text box.
8. Type your local SQL Server user name in the User name box, and then type your password in the Password text box.
9. In the Select the database on the server box, click Northwind, and then click OK.
10. In Server Explorer, expand your local SQL Server data connection, and then expand Stored Procedures.
11. In Server Explorer, drag the TestProc stored procedure from Stored Procedures to Form1.
12. On the View menu, click Code.
13. In the code editor, expand Windows Form Designer generated code.
    
    In the SqlCommand1 object, you see that the data type of the ntextParam parameter is NVarCharand the data type of the textParam parameter is VarChar.

Back to the top