Davide Franzoni
|
| Posted: 01/16/2003, 2:06 AM |
|
Hi,
I create a page to Insert, Update and Delete some table of my
SQLServer2000 database.
I use a View of the tables for the grid and the record page.
For the insert, modify and delete a used a my stored procedure (create to
work with more tables).
When I insert and delete all work fine, when I update the tables the page
retourn an implicit conversion error ("conversion from nvarchar to
numeric").
I think (and I am quite sure) that the parameter which generate the error is
the ID (primary key field) parameter that it is collegated to the "URL Id";
I use the same paramenter in the delete procedure (and there, I haven't any
problem).
I try to generate code ASP.NET C# and than ASP but it don't work.
I analise the code and I notice that in the delete function there is a
declaration of the ID paramenter but in the update function there isn't; I
try to add it but the page retourn the error that there are too many
parameters.
How I can do?
Please help me.
Thanks in advance
|
|
|
 |
|
