Hi this may help you...
if (fileupload1.HasFile)
{
byte [] productImage = fileupload1.FileBytes;
con.Open();
SqlCommand cmd = new SqlCommand("SP_SetUserDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Username", txtuname.Text);
cmd.Parameters.AddWithValue("@EmailID", txtEmail.Text);
cmd.Parameters.AddWithValue("@Password", txtpass.Text);
cmd.Parameters.AddWithValue("@Image", productImage);
cmd.Parameters.AddWithValue("@Hobbies", str);
cmd.Parameters.AddWithValue("@country", txtcountry.Text);
cmd.Parameters.AddWithValue("@Status", sts.ToString());
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
Gridview1.DataSource = ds;
BindGrid();
}
Stored Procedure
<pre>ALTER procedure [dbo].[SP_SetUserDetails]
(
@Username varchar(50),
@EmailID varchar(50),
@Password varchar(50),
@Image varbinary(max),
@Hobbies varchar(max),
@country varchar(50),
@Status varchar(50)
)
as
begin
Insert into UserDetails(UserName,EmailId,Password,PImage,Hobbies,Country,Status)values(@Username,@EmailID,@Password,@Image,@Hobbies,@country,@Status)
end