why am I getting this error ? ID field is identity, type int
Error message on update
=============== =============
Incorrect syntax near 'nvarchar'.
Must declare the scalar variable "@id".
Datasource
=============== ===
<asp:SqlDataSou rce ID="SqlDataSour ce1" runat="server"
....
UpdateCommand= "UPDATE [Properties] SET [PropertyName] = @PropertyName WHERE id = @id" >
<UpdateParamete rs>
<asp:Paramete r Name="ID" Type="Int32"/>
<asp:Paramete r Name="PropertyN ame" Type="String"/>
</UpdateParameter s>
...
Gridview
=============== =
<asp:GridView ID="GridView1" runat="server"
AutoGenerateCol umns="False"
DataSourceID="S qlDataSource1"
DataKeyNames="i d"
....>
