| | |
gridview update error
Please support our ASP.NET advertiser: Intel Parallel Studio Home
![]() |
•
•
Join Date: Feb 2008
Posts: 85
Reputation:
Solved Threads: 3
hiii, i am using asp.net 2005 and sql server 2005...i hav a page in which i have used gridview ant sql data source..
i have written the update command for the same..the problem is when i add the where clause in the query i get an error ,,,,here is the code
the error i get is:::
if i remove the where clause and the i update the whole column gets updated....
can ne1 help me,,,,,hope u understood my prob....pls reply,,its urgent
thnks in advance
i have written the update command for the same..the problem is when i add the where clause in the query i get an error ,,,,here is the code
ASP.NET Syntax (Toggle Plain Text)
UpdateCommand="UPDATE SMEtre_Master SET FirstName =@FirstName, LastName =@LastName, Type_of_SME =@Type_of_SME, Agency_Name =@Agency_Name, Email =@Email, Address =@Address, Phone =@Phone, Mobile =@Mobile, Fax =@Fax, Experience =@Experience, City =@City, State =@State where SME_Id=@SME_Id"
ASP.NET Syntax (Toggle Plain Text)
Exception Details: System.Data.SqlClient.SqlException: Must declare the scalar variable "@SME_Id".
can ne1 help me,,,,,hope u understood my prob....pls reply,,its urgent
thnks in advance
Johnny.G
![]() |
Similar Threads
- conversion problem (ASP.NET)
- conversion from string to double error (VB.NET)
- Editing a hyperlinkcontrl in a gridview (ASP.NET)
- C# .NET Gridview (C#)
Other Threads in the ASP.NET Forum
- Previous Thread: How is 3Tier architecture implemented in ASP.NET
- Next Thread: excel file upload problem
| Thread Tools | Search this Thread |
.net 2.0 3.5 activexcontrol advice ajax alltypeofvideos asp asp.net bc30451 bottomasp.net browser businesslogiclayer button c# c#gridviewcolumn checkbox click commonfunctions compatible confirmationcodegeneration content contenttype countryselector courier css dataaccesslayer database datagrid datagridview datagridviewcheckbox datalist deadlock development dgv dropdownlist dropdownmenu edit expose flash flv formatdecimal forms formview gridview homeedition iframe iis javascript jquery list listbox login menu microsoft mono mouse mssql multistepregistration nameisnotdeclared news numerical objects order panelmasterpagebuttoncontrols problem radio ratings reportemail rotatepage save schoolproject search security serializesmo.table silverlight smartcard software sql-server sqlserver2005 suse textbox tracking unauthorized validation vb.net video videos virtualdirectory vista visual-studio visualstudio web webapplications webarchitecture webdevelopemnt webprogramming webservice xml youareanotmemberofthedebuggerusers





