ASP.NET

ASP.NET RSS

gridview update error

Please support our ASP.NET advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!

•

Join Date: Feb 2008

Posts: 85

Reputation: johnny.g is an unknown quantity at this point

Solved Threads: 3

johnny.g

Offline

Junior Poster in Training

gridview update error

Feb 27th, 2008

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

Help with Code Tags

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"

the error i get is:::

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
 
Exception Details: System.Data.SqlClient.SqlException: Must declare the scalar variable "@SME_Id".
Exception Details: System.Data.SqlClient.SqlException: Must declare the scalar variable "@SME_Id".

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

Johnny.G