Gridview Problem

[monika_vasvani]

Hi all I have one procedure in sqlserver. create procedure pro_UpdateCompanyData(@oldvalue varchar(50),@newvalue varchar(50)) as set nocount on Update CompanyType Set CompanyType.type=@newvalue where CompanyType.type=@oldvalue Go Type is my columnname in table CompanyType. now I have one gridview on page.I did Editcolumn and add edit,update and cancle button. i write some code on gridview_Rowupdated event. SqlDataSource1.UpdateCommandType=SqlDataSourceCommandType.StoredProcedure; SqlDataSource1.UpdateParameters.Add(new Parameter("@oldvalue", System.TypeCode.String, ((string)Session["oldvalue"]))); SqlDataSource1.UpdateParameters.Add(new Parameter("@newvalue", System.TypeCode.String, newvalue)); SqlDataSource1.UpdateCommand ="pro_UpdateCompanyData"; "@type is not a parameter for procedure pro_UpdateCompanyData." this error arise in this code. I am not getting this point.pls suggest me. Thanks monika

[Abhijit Jana]

monika_vasvani wrote:

"@type is not a parameter for procedure pro_UpdateCompanyData."

Error clearly says, you are passing wrong parameters to the store procedures.

cheers, Abhijit