Update Error

[msomar]

When I click button Update this error is cccurred : Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near 'nvarchar'. my SqlDataSource is:

the parameter :

is a session parameter.

I am waiting please guide me.

[loyal ginger]

When you click the Update button, some other command was executed. Since I don't see a statement containing "nvarchar" in the code you have posted, I believe you have hooked up the event handler to somewhere else. You can track down the problem using your debugging environment and pinpoint the problematic statement.

[Vimalsoft Pty Ltd]

I don't use Wizards to do my database work. But this parameter isn't supposed to have a data type ?

Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/