Here i will demonstrates how to upload image and then save into Sql data base in ASP.NET.application.For this i have taken a File Upload Control.button and grid view.Before going to insert the Image into Database i am checking the the file upload in empty or not.If it is not empty then go to insertion procedure
Code behind:
protected void btnImgUpload_Click(object sender, EventArgs e)
{
string strImg= txtImgName.Text;
if (ImgFileUpload.PostedFile != null && ImgFileUpload.PostedFile.FileName != "")
{
byte[] strImageSize = new byte[ImgFileUpload.PostedFile.ContentLength];
HttpPostedFile uploadImage = ImgFileUpload.PostedFile;
uploadImage.InputStream.Read(imageSize, 0, (int)ImgFileUpload.PostedFile.ContentLength);
SqlConnection cn=new SqlConnection("Userid=sa;Password=123;Database=employee");
try
{
cmd.parameter.clear();
cmd.Parameters.Add("@ImageName", SqlDbType.VarChar).Value = strImg.ToString();;
cmd.Parameters.Add("@Imagesize", SqlDbType.Image,imageSize.Length).Value = strImageSize;
cn.Open();
cmd = new SqlCommand("SaveImagerecord", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExcuteNonQuery();
}
catch(exception ex)
{
messageBox.show(ex.message);
}
finally
{
cn.Close();
}
gvimages.DataBind();
}
}
Stored Procedure://stored procedure to insert the Images into in Sqlserver Table CREATE PROCEDURE SaveImagerecord ( @ImageName VarChar(100), @Imagesize byte ) AS INSERT INTO Images(ImageName,Imagesize)VALUES (@ImageName,@Imagesize);
1 comment:
Thanks for the post!!!
Post a Comment