I have datafiled Photo with datatype Image in sql server . i want to use it to store Image. how i canwrite a code in windows Application using C# to insert and retrive image from the database to viev it on a Picture t control. please provide me few lines of sample code


dinesh Rana

__________________
dinesh Rana

Insure it will help u much.
http://www.codeproject.com/cs/database/albumviewer.asp

Always:),
Hovik Melkomian.

what is the error in this code whenever i i run the code i recieve an error at Bitmap bmp = new Bitmap(stream);
as addtional inforamtion



string strcmd = string.Format("select photo from employee where employeeid = '1199'");
SqlCommand cmd =new SqlCommand(strcmd,conn);
byte[] b = (byte[])cmd.ExecuteScalar();
    if(b.Length > 0)
{

System.IO.MemoryStream stream = new System.IO.MemoryStream(b, true); stream.Write(b, 0, b.Length);

        Bitmap bmp = new Bitmap(stream);


                //if(bmp.Width>500 && bmp.Height >300)
                {
                // Bitmap bmp1 = new Bitmap(bmp,new Size(500,300));
                // photo.Image = bmp1;
                }
                //else
                {
                // photo.Image = bmp;
                }



            }
        conn.Close();
        }

dinesh Rana

It works fine dear. Did u edited the codes?!
What is this?!


Always:),
Hovik Melkomian.

i inserted the photographs in the server sucess fully but when i want to retrive photographs back from the server it gives me an error
invalid arguments at


Bitmap bmp = new Bitmap(stream)
i tried it in number of ways but i wont get it.

Please help me to get out of this

dinesh Rana

I guess u miss a Reference. check the documentation again for that?!

Always:),
Hovik Melkomian.

I Need to create a table in which I have to add Image Datatype column.My environment is win 2000 and SQL server 2000.front end is VB.Net.I need this at the earliest.How to ad a .jpeg file into that table using blobs.
regards
ravi