hi guys

i have a "web page" with two "web user controls".

each web user control has a sql data source and a corresponding formview on it.

formview1 on the first web user control works fine and allows me to update it.

formview2 on the second web user control is visable and i can press the edit button. when i press the update button i get the following error:


Server Error in '/intranet' Application.

The data types text and nvarchar are incompatible in the equal to operator.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: The data types text and nvarchar are incompatible in the equal to operator.

Source Error:


An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


any ideas???????

This is a problem in your query because you can not compare a text to a nvarchar using equal operator. Kindly do the proper conversions to solve this. if you are unable to slove it post ur SQL code here