M
Mark
Hi,
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.DetailsViewUpdateEventArgs) Handles
DetailsView1.ItemUpdating
SqlDataSource1.UpdateCommand = "UPDATE mytable set name= @myname"
SqlDataSource1.UpdateParameters.Add("@myname", SqlDbType.NVarChar, na)
SqlDataSource1.Update()
End Sub
I don't see what's wrong here.
Thanks for help
Mark
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.DetailsViewUpdateEventArgs) Handles
DetailsView1.ItemUpdating
SqlDataSource1.UpdateCommand = "UPDATE mytable set name= @myname"
SqlDataSource1.UpdateParameters.Add("@myname", SqlDbType.NVarChar, na)
SqlDataSource1.Update()
End Sub
I don't see what's wrong here.
Thanks for help
Mark