I have created a basic database that is only one table. One of the fields is LogPicture with type of image.
I just want to go into the table and manually place a picture in the table, but it seems like I can not get the format down. I have tried including the picture I want into the project, but no dice. I've also tried putting the physical pathname (on the harddrive) and the web address of this field in there. Suggestions please?
*bump*
I am basically just looking for the syntax of how an image is inserted. Anyone..... please?|||
Image data is stored as binary stream in SQL Server. You can either use bcp.exe utility to insert BLOB data (image/text/ntext) or write your own code to input binary stream to the column. You can take a look at this post:
http://forums.asp.net/thread/1257487.aspx
And here is a article that introduces bcp utility:
http://msdn2.microsoft.com/en-us/library/ms162802.aspx
No comments:
Post a Comment