-1

how to save the jpg file into database using file upload control?
how to retrive that stored jpg file from database and show on image control.
i have table has two fields Id(int),imageData(image).

4
Contributors
3
Replies
5
Views
7 Years
Discussion Span
Last Post by mail2saion
0

>how to save the jpg file into database using file upload control?

Use/learn ADO.NET classes.

>how to retrive that stored jpg file from database and show on image control.

1. Retrieve binary data from database and save into a file (say temp.gif).
2. Set ImageUrl property of Image control.

0

how to save the jpg file into database using file upload control?
how to retrive that stored jpg file from database and show on image control.
i have table has two fields Id(int),imageData(image).

I think saving image in database is not a good practice.finally it will slow down your database and retrieved image quality wont be good.so its always good to save image file in disk.

-1

To upload file into server follow the below sample code:

protected void cmd_Upload_Click(object sender, EventArgs e)
    {
        string s_Image_Name = txt_Image_Name.Text.ToString();
        if (FileUpload1.PostedFile != null && FileUpload1.PostedFile.FileName != "")
        {
            byte[] n_Image_Size = new byte [FileUpload1.PostedFile.ContentLength];
            HttpPostedFile Posted_Image = FileUpload1.PostedFile;
            Posted_Image.InputStream.Read(n_Image_Size, 0, (int)FileUpload1.PostedFile.ContentLength);

            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["TestConnection"].ConnectionString);

            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = "INSERT INTO Images(Name,[Content],Size,Type)" +
                              " VALUES (@Image_Name,@Image_Content,@Image_Size,@Image_Type)";
            cmd.CommandType = CommandType.Text;
            cmd.Connection = conn;

            SqlParameter Image_Name = new SqlParameter("@Image_Name", SqlDbType.VarChar, 500);
            Image_Name.Value = txt_Image_Name.Text;
            cmd.Parameters.Add(Image_Name);

            SqlParameter Image_Content = new SqlParameter("@Image_Content", SqlDbType.Image, n_Image_Size.Length);
            Image_Content.Value = n_Image_Size;
            cmd.Parameters.Add(Image_Content);

            SqlParameter Image_Size = new SqlParameter("@Image_Size", SqlDbType.BigInt, 99999);
            Image_Size.Value = FileUpload1.PostedFile.ContentLength;
            cmd.Parameters.Add(Image_Size);

            SqlParameter Image_Type = new SqlParameter("@Image_Type", SqlDbType.VarChar, 500);
            Image_Type.Value = FileUpload1.PostedFile.ContentType;
            cmd.Parameters.Add(Image_Type);


            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
        }
    }

To display the image form database follow the below post:
http://shawpnendu.blogspot.com/2009/12/display-images-in-gridview-from-sql.html

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.