how to store image in sql

Hi,

Check the below URL:

http://aspalliance.com/articleViewer.aspx?aId=138&pId=[^]

Hope you will get the solution of your problem.

Thanks
Mehul Thakkar

--image_data is an IMAGE field           
SqlCommand cmd = new SqlCommand("SELECT image_data FROM GRAPHIC WHERE ID = 5", cn);

--Load into Byte Array
byte[] b = (byte[])cmd.ExecuteScalar();
MemoryStream ms = new MemoryStream(b);

--Load stream into an image object
Image img = Image.FromStream(ms);
pictureBox1.Image = img;

hi try this code


1.) make attribute picture type nvarchar(100)
2.) make img folder in website folder
3.) take file upload control fileupload1

<b>Insert image in Database</b>:

if(fileuplaod1.filename!=null)
{
fileupload1.savefileAs(server.mapPath("img//")+fileupload1.filename.tosting());//this will save your image in img folder
String path=fileuplaod1.filename.tostring();
}
//then execute insert query like

string query="insert into <table name> values ('"+tztbox1.text+"',....,'"+path+"')";
//this query will save your img path or image name in your database.


<b>Retrive image from the database:</b>

String str="select * from <Table name>";
com=new sqlcommand(str,connection);
Sqldatareader rd=com.executeReader();
Image1.imagerl=server.mapPath("img//")+reader["picture"].toString();



IF you get your answer then please give me marking/rating

thanks