how to call sp in aspx.cs page to save image and radbutton in table?

hi...to upload image into db..use "Fileupload control"..
..Here is the sample code..

if (FileUpload1.HasFile)
        {
            try
            {
                string filename = Path.GetFileName(FileUpload1.FileName);
                HttpPostedFile Image = FileUpload1.PostedFile;
                byte[] myimage = new byte[FileUpload1.PostedFile.ContentLength];
                Image.InputStream.Read(myimage, 0, (int)FileUpload1.PostedFile.ContentLength);


                cmd.Parameters.AddWithValue("@Logo", myimage);
                lblError.Text = "Upload status: File uploaded!";
            }
            catch (Exception ex)
            {

                lblError.Text = "Upload status: The file could not be uploaded. The following error occured: " + ex.Message;
            }

..use this code to save image in db..
----cmd.Parameters.AddWithValue("@Logo", myimage);----
is the command..which add the image to db...

Hi,

Try this:

SqlParameter parReturn;
        int i;
        try
        {
            con.Open();
            Cmd = new SqlCommand("spTest", con);
            Cmd.CommandType = CommandType.StoredProcedure;
            Cmd.Parameters.Add(new SqlParameter("@textbox", Textbox1.Text));
            Cmd.Parameters.Add(new SqlParameter("@radiobutton", Radiobutton1.Value));
            Cmd.Parameters.Add(new SqlParameter("@image ", Image1.Text));
            parReturn = Cmd.Parameters.Add(new SqlParameter("ReturnValue", SqlDbType.Int));
            parReturn.Direction = ParameterDirection.Output;
            Cmd.ExecuteNonQuery();
            i = Convert.ToInt32(Cmd.Parameters["ReturnValue"].Value.ToString());
        }
        catch(Exception ex)
        {
            i = 0;
        }
        finally
        {
            con.Close();
        }
        return i;
    }

All the best.

-AK

i tried simple withot sp

  if (imageUpload.HasFile)
        {
            SqlConnection con = new SqlConnection("Data Source=accerlap2;Initial Catalog=Fahad;User ID=sa;Password=p@ssword;");
            byte[] img = new byte[imageUpload.PostedFile.ContentLength];
            HttpPostedFile myimg=imageUpload.PostedFile;
            myimg.InputStream.Read(img, 0, imageUpload.PostedFile.ContentLength);
            SqlCommand cmd=new SqlCommand("Insert into tblImage(iName,iAddress,iImage) values(@Name,@Address,@Image)",con);
           
            cmd.Connection = con;
            SqlParameter name = new SqlParameter("@Name", SqlDbType.VarChar, 50);
            name.Value = txtName.Text;
            cmd.Parameters.Add(name);
            SqlParameter Address = new SqlParameter("@Address", SqlDbType.VarChar, 50);
            Address.Value = txtAddress.Text;
            cmd.Parameters.Add(Address);
            SqlParameter image = new SqlParameter("@Image", SqlDbType.Image);
            image.Value = img;
            cmd.Parameters.Add(image);

            con.Open();
            cmd.ExecuteNonQuery();
           
            
           
            lblMessage.Text = "Save Successfully";
            con.Close();
            txtName.Text = "";
            txtAddress.Text = "";
        }
        else
            lblMessage.Text = "Can't upload.....";
}