Sqldatasource Update Parameters Code Behind Credit' title='Sqldatasource Update Parameters Code Behind Credit' />Incorrect syntax near nvarchar in update ASP.NET Gridview. Very simple question but all the answer I read over the web doesnt apply.I try to do an update on a ASP.NET Gridview but when I click on update, I get this error Incorrect Syntax near nvarchar.The scalar variable int.ID must be declare.Here is my datasource.I guess the problem come from here but I cant see where.Sql. Data. Source IDSql.Data. Source. 1 runatserver Connection.Stringlt Connection.Strings connexion.Dev. Delete. Very simple question but all the answer I read over the web doesnt apply. Download Things For Sims 2 Pc . I try to do an update on a ASP.NET Gridview but when I click on update, I get this error.PROFESSIONAL. ASP.NET MVC 5 Jon Galloway Brad Wilson K.Scott Allen David Matson.Page v. CommandDELETE FROM tblBug WHERE int.ID int. ID. Select.CommandSELECT int.ID,str. Titre,str.Description,int. StatusFK,int.TypeFK,int. Express Helpline Get answer of your question fast from real experts.SeriousnessFK FROM tblBug.Update. CommandUPDATE tblBug SET str.Titre str. Titre ,str.Description str. Description ,int.StatusFK int. You cant add parameters to SqlDataSource.You can add SqlCommand instead.Try something similar like this string updateStatement Update myTable set userName.StatusFK ,int. TypeFK int.TypeFK ,int. SeriousnessFK int.SeriousnessFK WHERE int.ID int. ID. Delete.Parameters. Parameter Nameint.ID TypeInt. 32. Delete.Parameters. Update.Parameters. Parameter Nameint.ID TypeInt. 32. Parameter Namestr.Titre TypeString.Parameter Namestr.Description TypeString.Parameter Nameint.StatusFK TypeInt.Parameter Nameint.TypeFK TypeInt. Parameter Nameint.SeriousnessFK TypeInt.Update. Parameters.Sql. Data. Source.Thanks for your help in advance EDIT EDIT EDITWell, I wanted to use SQL Profiler but it seems that its not in my version SQL server 2.Express so I tried another sql profiler that is open source but I never understood how it worked and it was always crashing.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |