[DotNetDevelopment] Re: SQL Images(newbie question)

2008-11-10 Thread SLM
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:

[DotNetDevelopment] Re: SQL Images(newbie question)

2008-11-10 Thread BigJ
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

[DotNetDevelopment] Re: SQL Images(newbie question)

2008-11-10 Thread [EMAIL PROTECTED]
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

[DotNetDevelopment] Re: SQL Images(newbie question)

2008-11-09 Thread Brandon Betances
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

[DotNetDevelopment] Re: SQL Images(newbie question)

2008-11-09 Thread BigJ
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