Saving an image to SQL Server's image datatype

Or search.live.com.

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"Stuart Ainsworth" <stuart.ainsworth.RemoveThis@gmail.com> wrote in message
news:09cb5237-9e9f-440c-99df-74b0fa4d676e@34g2000hsh.googlegroups.com...
On Jul 17, 11:38 am, "Nathan Sokalski" <nsokal....RemoveThis@kyledavidgroup.com>
wrote:
> I am using ASP.NET 2.0, and need to know how to save and use an image that
> is stored in an SQL Server image datatype. How can I do this using
> ASP.NET?
> Thanks.

google is your friend...

http://www.codeproject.com/KB/web-image/PicManager.aspx
http://aspalliance.com/articleViewer.aspx?aId=138
http://bytes.com/forum/thread287108.html

HTH,
Stu
 >> Stay informed about: Saving an image to SQL Server's image datatype 

A well-kept secret

"TheSQLGuru" wrote:

> Or search.live.com.
>
> --
> Kevin G. Boles
> Indicium Resources, Inc.
> SQL Server MVP
> kgboles a earthlink dt net
>
>
> "Stuart Ainsworth" <stuart.ainsworth.RemoveThis@gmail.com> wrote in message
> news:09cb5237-9e9f-440c-99df-74b0fa4d676e@34g2000hsh.googlegroups.com...
> On Jul 17, 11:38 am, "Nathan Sokalski" <nsokal....RemoveThis@kyledavidgroup.com>
> wrote:
> > I am using ASP.NET 2.0, and need to know how to save and use an image that
> > is stored in an SQL Server image datatype. How can I do this using
> > ASP.NET?
> > Thanks.
>
> google is your friend...
>
> http://www.codeproject.com/KB/web-image/PicManager.aspx
> http://aspalliance.com/articleViewer.aspx?aId=138
> http://bytes.com/forum/thread287108.html
>
> HTH,
> Stu
>
>
>
 >> Stay informed about: Saving an image to SQL Server's image datatype 

On Jul 18, 8:19 am, Linchi Shea <LinchiS... DeleteThis @discussions.microsoft.com>
wrote:
> A well-kept secret
>
>
>
> "TheSQLGuru" wrote:
> > Or search.live.com.  
>
> > --
> > Kevin G. Boles
> > Indicium Resources, Inc.
> > SQL Server MVP
> > kgboles a earthlink dt net
>
> > "Stuart Ainsworth" <stuart.ainswo... DeleteThis @gmail.com> wrote in message
> >news:09cb5237-9e9f-440c-99df-74b0fa4d676e@34g2000hsh.googlegroups.com...
> > On Jul 17, 11:38 am, "Nathan Sokalski" <nsokal... DeleteThis @kyledavidgroup.com>
> > wrote:
> > > I am using ASP.NET 2.0, and need to know how to save and use an image that
> > > is stored in an SQL Server image datatype. How can I do this using
> > > ASP.NET?
> > > Thanks.
>
> > google is your friend...
>
> >http://www.codeproject.com/KB/web-image/PicManager.aspx
> >http://aspalliance.com/articleViewer.aspx?aId=138
> >http://bytes.com/forum/thread287108.html
>
> > HTH,
> > Stu- Hide quoted text -
>
> - Show quoted text -

Hi,
Saving image in database is not a good idea, this activity create
unnessary bulky database.
Ok.. If you want to save image in the database, you can use varbinary
datatype insteda of image, microsoft will remove image datatype in
there earlier version.

Rahul
 >> Stay informed about: Saving an image to SQL Server's image datatype 

I've even heard of yahoo.com, but that might be a rumor.


ML

---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/
 >> Stay informed about: Saving an image to SQL Server's image datatype 

> Saving image in database is not a good idea, this activity create
> unnessary bulky database.

It depends. If you have a large number of small images, you may be better
off storing them in the database. If you have a relatively small number of
large images, it may be better to keep them in the filesytem. If you want to
stream from these images, keep them outside of the database.

Linchi

"Rahul" wrote:

> On Jul 18, 8:19 am, Linchi Shea <LinchiS....RemoveThis@discussions.microsoft.com>
> wrote:
> > A well-kept secret
> >
> >
> >
> > "TheSQLGuru" wrote:
> > > Or search.live.com.
> >
> > > --
> > > Kevin G. Boles
> > > Indicium Resources, Inc.
> > > SQL Server MVP
> > > kgboles a earthlink dt net
> >
> > > "Stuart Ainsworth" <stuart.ainswo....RemoveThis@gmail.com> wrote in message
> > >news:09cb5237-9e9f-440c-99df-74b0fa4d676e@34g2000hsh.googlegroups.com...
> > > On Jul 17, 11:38 am, "Nathan Sokalski" <nsokal....RemoveThis@kyledavidgroup.com>
> > > wrote:
> > > > I am using ASP.NET 2.0, and need to know how to save and use an image that
> > > > is stored in an SQL Server image datatype. How can I do this using
> > > > ASP.NET?
> > > > Thanks.
> >
> > > google is your friend...
> >
> > >http://www.codeproject.com/KB/web-image/PicManager.aspx
> > >http://aspalliance.com/articleViewer.aspx?aId=138
> > >http://bytes.com/forum/thread287108.html
> >
> > > HTH,
> > > Stu- Hide quoted text -
> >
> > - Show quoted text -
>
> Hi,
> Saving image in database is not a good idea, this activity create
> unnessary bulky database.
> Ok.. If you want to save image in the database, you can use varbinary
> datatype insteda of image, microsoft will remove image datatype in
> there earlier version.
>
> Rahul
>
 >> Stay informed about: Saving an image to SQL Server's image datatype 

OK, but regardless of my choice, I need to know what my code should look
like to get them into and out of the DB. I have used the FileUpload control
before to upload a file to the file system, but I have never put an image
(or any other type of file) into a database. If you know of any examples, it
would be extremely helpful. Thanks.

Nathan Sokalski
njsokalski.TakeThisOut@hotmail.com
http://www.nathansokalski.com/

"Linchi Shea" <LinchiShea.TakeThisOut@discussions.microsoft.com> wrote in message
news:463D76E8-BA5B-48AF-9458-26E4151D8EDB@microsoft.com...
>> Saving image in database is not a good idea, this activity create
>> unnessary bulky database.
>
> It depends. If you have a large number of small images, you may be better
> off storing them in the database. If you have a relatively small number of
> large images, it may be better to keep them in the filesytem. If you want
> to
> stream from these images, keep them outside of the database.
>
> Linchi
>
> "Rahul" wrote:
>
>> On Jul 18, 8:19 am, Linchi Shea <LinchiS....TakeThisOut@discussions.microsoft.com>
>> wrote:
>> > A well-kept secret
>> >
>> >
>> >
>> > "TheSQLGuru" wrote:
>> > > Or search.live.com.
>> >
>> > > --
>> > > Kevin G. Boles
>> > > Indicium Resources, Inc.
>> > > SQL Server MVP
>> > > kgboles a earthlink dt net
>> >
>> > > "Stuart Ainsworth" <stuart.ainswo....TakeThisOut@gmail.com> wrote in message
>> > >news:09cb5237-9e9f-440c-99df-74b0fa4d676e@34g2000hsh.googlegroups.com...
>> > > On Jul 17, 11:38 am, "Nathan Sokalski" <nsokal....TakeThisOut@kyledavidgroup.com>
>> > > wrote:
>> > > > I am using ASP.NET 2.0, and need to know how to save and use an
>> > > > image that
>> > > > is stored in an SQL Server image datatype. How can I do this using
>> > > > ASP.NET?
>> > > > Thanks.
>> >
>> > > google is your friend...
>> >
>> > >http://www.codeproject.com/KB/web-image/PicManager.aspx
>> > >http://aspalliance.com/articleViewer.aspx?aId=138
>> > >http://bytes.com/forum/thread287108.html
>> >
>> > > HTH,
>> > > Stu- Hide quoted text -
>> >
>> > - Show quoted text -
>>
>> Hi,
>> Saving image in database is not a good idea, this activity create
>> unnessary bulky database.
>> Ok.. If you want to save image in the database, you can use varbinary
>> datatype insteda of image, microsoft will remove image datatype in
>> there earlier version.
>>
>> Rahul
>>
 >> Stay informed about: Saving an image to SQL Server's image datatype 

Nathan Sokalski laid this down on his screen :
> OK, but regardless of my choice, I need to know what my code should look like
> to get them into and out of the DB. I have used the FileUpload control before
> to upload a file to the file system, but I have never put an image (or any
> other type of file) into a database. If you know of any examples, it would be
> extremely helpful. Thanks.
>

I use a store procedure with a parameter of type "image". Inside that
procedure you can use that variable to insert into the table.

When calling that stored procedure from the .Net code, I use parameters
to supply the data. The image-type parameter is then filled with the
byte[] containing that file.

Hans Kesting
 >> Stay informed about: Saving an image to SQL Server's image datatype 

Hey Nathan,

An article on Large Object Storage in a Database or a Filesystem
http://research.microsoft.com/research/pubs/view.aspx?msr_tr_id=MSR-TR-2006-45


If you want to know how I do it:

I use and Image.aspx page and stream the image to that page then in and
other page i use and image controle and set the image.aspx page as image
path.
To get the connection I use linq in the example I make the query with linq
but that is not fast with large tables so you’re better off using stored
procedures with linq.

example:
The page with the image control
imgImageControl.ImageUrl = "Image.aspx?Id=2";


The image.aspx page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArgs) Handles Me.Load
Try
Dim objNV As NameValueCollection
Dim pic() As Byte = Nothing
Dim strID As String = ""
objNV = Request.QueryString()
If Not objNV.Count = 0 Then
strID = objNV.Item("ID")
Else
pic = Session("Id")
If pic Is Nothing Then
strID = User.Identity.Name.ToString()
End If
End If
If Not strID = "" Then
Dim db As New
myDB(ConfigurationManager.ConnectionStrings("sql1").ConnectionString)
Dim Updateprofiel = (From p In db.Profiels Where p.Prof_ID =
strID Select p.Foto).ToList()(0)
If Not Updateprofiel Is Nothing Then
pic = Updateprofiel.ToArray()
End If
db.Connection.Close()
End If
If Not pic Is Nothing Then
Response.ContentType = "image/jpeg"
Response.OutputStream.Write(pic, 0, pic.Length)
End If
Catch ex As Exception
MsgBox(ex.ToString, MsgBoxStyle.Critical, "Big error run
away!!!!!")
End Try

End Sub

steve


"Nathan Sokalski" wrote:

> I am using ASP.NET 2.0, and need to know how to save and use an image that
> is stored in an SQL Server image datatype. How can I do this using ASP.NET?
> Thanks.
>
>
>
 >> Stay informed about: Saving an image to SQL Server's image datatype