BigJ, Here's a working sample.
1) In SQL Server define your image column (VARBINARY(MAX)). You may
want to create a separate table for the image and relate it via a FK
if the original table is one that is searched often for other values.
2) Create a stored procedure to update the image:
Brandon,
thanks. I was doing that before, but I just wanted to know how to
use the "image" datatype since it's offered as a data type. Is it
prevalently used or do most just reference the image pathway?
jon
On Nov 10, 1:04 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> good answer BigJ
good answer BigJ,
I just faced with this problem some weeks ago, I think you should search in
you MSDN with this keyword:
"Working with Large Value Data Types (ADO.NET)"
hopefuly, it will help you.
B'Rgds
sugi
On Mon, Nov 10, 2008 at 1:01 PM, Brandon Betances <[EMAIL PROTECTED]>wrote:
> If I
If I were you, and im not, I would store a reference to the location of the
image in the database and reference that. Saves alot of bandwidth and space
on the SQL server. Or even better, store it in XML.
On Mon, Nov 10, 2008 at 12:43 AM, BigJ <[EMAIL PROTECTED]> wrote:
>
> FYI, I'm trying to load
FYI, I'm trying to load it manually in Visual Web Developer, not from
the Web.
Thanks
On Nov 9, 9:37 pm, BigJ <[EMAIL PROTECTED]> wrote:
> How do you load images into a table? I'm using Visual Web Developer,
> and there is a selectable datatype called image. I've selected the and
> created a di