System.IndexOutOfRangeException

[asifbhura]

Dear

I am facing this error with field name of table

the code if below

Sql server code

Store procedure

CREATE PROCEDURE SP_AddUsedCar @PersonID Integer, @BrandName varchar(255), @cper varchar(100),@price varchar(50),@stat varchar(50),
@MFYear Integer, @ImageFile varchar(255),@Description varchar(1000), @CountryID Integer,
@CityID varchar(50), @Approved char, @ImgFileName varchar(50) OUTPUT AS
DECLARE @UsedCarID Integer

INSERT INTO UsedCars (PersonID,BrandName,cper,price,stat, MFYear, Description, CountryID, CityID, Approved)
Values (@PersonID,@BrandName,@cper,@price,@stat,@MFYear,@Description,@CountryID,@CityID,@Approved)

SET @UsedCarID = @@IDENTITY
SET @ImgFileName = 'usedcar_'+Convert(varchar(25), @UsedCarID) + SUBSTRING(@ImageFile,PATINDEX('%.%',@ImageFile),LEN(@ImageFile))
UPDATE UsedCars SET ImageFile = @ImgFileName WHERE UsedCarID = @UsedCarID
GO


C# code to add and edit data:

public string addUsedCar(int personID, string brandName,string cper,string price,string stat, int mfYear, string imageFile,
string desc, int countryid, string cityid, char approved)
{
Connect();
SqlCommand _cmd = new SqlCommand("SP_AddUsedCar",_cnn);
SqlParameter _stat = new SqlParameter("@stat", SqlDbType.VarChar, 50);
_stat.Value = stat;
_cmd.Parameters.Add(_stat);

same thing for all parameters

same procedure i have created to edit data.

It works well for adding new records.

now the code where i am facing error in bolded line as System.IndexOutOfRanceException : stat

where "stat" is field name

hdnUsedCarID.Value = Convert.ToString(usedCarID);
hdnPictureFlag.Text = "1";
txtBrandName.Text = reader["BrandName"].ToString();
txtDesc.Text = reader["Description"].ToString();
txtprice.Text= reader["price"].ToString();
//txtPhoto.Value = reader["ImageFile"].ToString();
imgPhoto.Attributes.Add("src","../photos/usedcars/"+reader["ImageFile"].ToString());
sltYear.Items.FindByValue(reader["MFYear"].ToString()).Selected = true;
CountryList.Items.FindByValue(reader["CountryID"].ToString()).Selected = true;
cmbsale.Items.FindByValue(reader["stat"].ToString()).Selected = true;


Waiting for reply.

Regards,
ASIF