how to save image into databse using store proc...

See more:

C#

ASP.NET

SQL-Server

Sir,

I am trying to upload image into database using store proc m having a fileupload control and upload button on upload button click image should be inserted into database but m getting error..pls help thanks in advance..
getting this error
"Procedure or function 'upload_image' expects parameter '@Property_Img', which was not supplied."

Database design and store proc:

create table tbl_property_img
(
   Image_Id int identity(1,1)primary key,
   Property_Img image null,
)


create procedure dbo.upload_image
   @Property_Img image
as
begin
   insert into tbl_property_img(Property_Img)values(@Property_Img)
end

Code Behind:

int filelength = FileUpload1.PostedFile.ContentLength;
        byte[] imagebytes = new byte[filelength];
        FileUpload1.PostedFile.InputStream.Read(imagebytes,0,filelength);
        SqlConnection cn = new SqlConnection(str);
        SqlCommand cmdinsimg = new SqlCommand("dbo.upload_image", cn);
        cmdinsimg.CommandType = CommandType.StoredProcedure;
        //cmdinsimg.Parameters.AddWithValue("@Property_Img", FileUpload1.);
        SqlParameter[] prms = new SqlParameter[1];
        prms[0] = new SqlParameter("@Property_Img",SqlDbType.Image);
        prms[0].Value = imagebytes;
        cn.Open();
        cmdinsimg.ExecuteNonQuery();
        cn.Close();