View Single Post
Old August 2nd, 2007, 03:31 PM
hertendreef hertendreef is offline
Friend of Wrox
Join Date: Apr 2006
Location: , , .
Posts: 160
Thanks: 0
Thanked 0 Times in 0 Posts
Default problem with Updating a table


i try to update field 'name' (nvarchar(5) in sql server) of table 'mytable'.
This happens in event DetailsView1_ItemUpdating with my own code.
It works without parameters (i know, bad way) like this:
SqlDataSource1.UpdateCommand = "UPDATE mytable set name= '" & na & "'"

But when using parameters like here below, i get the error:
"Input string was not in a correct format"

Protected Sub DetailsView1_ItemUpdating(ByVal sender As Object, ByVal e As
System.Web.UI.WebControls.DetailsViewUpdateEventAr gs) Handles
SqlDataSource1.UpdateCommand = "UPDATE mytable set name= @myname"
SqlDataSource1.UpdateParameters.Add("@myname", SqlDbType.NVarChar, na)
End Sub

I don't see what's wrong here.
Thanks for help