file upload control

[shruti patel]

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).

[kvprajapati]

>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.

[mithranvm]

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.

[mail2saion]

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