Image handling with SQL

I am using SQL Express and I do not know how to add images to my database. I've created a dataset and linked it to datalists so everything is perking along except I'm just clueless on the image handling. I create a resx file thinking that work except I don't know how to coordinate it with the data. In Access it is an easy thing to add an image OLE object to my database which gives me a load of options in reports so you would think that it would handle similarly here, but I'm not making any progress and after a week an half of hunting around I'm hoping someone here will clue me in.

Thanks

Have a look at this
http://www.dotnetspider.com/Question117.aspx

HTH

Image - Paste into table vs. Insert Object linked or unlinked

I have a form in which one of the columns will show a picture. Is there any
difference when using the form if I paste in the image or use "Insert
Object".
When looking at the underlying table after closing the form:
If the image is pasted, it shows "Picture" as the value in the field
If the image is put in via Insert Object and it is unlinked, it shows
"Package"
When I look at the "Bound Object Frame", I see no difference in values. I
see identical images when viewing the form.
My initial take on it is if the image won't change, go ahead and paste it
in. If the document may change, then it should be linked.
Is there a preferred method?
What program are you using?
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dkline" <Dkline001@.comcast.net> wrote in message
news:%23v1xUqpHFHA.1860@.TK2MSFTNGP15.phx.gbl...
>I have a form in which one of the columns will show a picture. Is there any
>difference when using the form if I paste in the image or use "Insert
>Object".
> When looking at the underlying table after closing the form:
> If the image is pasted, it shows "Picture" as the value in the field
> If the image is put in via Insert Object and it is unlinked, it shows
> "Package"
> When I look at the "Bound Object Frame", I see no difference in values. I
> see identical images when viewing the form.
> My initial take on it is if the image won't change, go ahead and paste it
> in. If the document may change, then it should be linked.
> Is there a preferred method?
>

Image - Paste into table vs. Insert Object linked or unlinked

I have a form in which one of the columns will show a picture. Is there any
difference when using the form if I paste in the image or use "Insert
Object".
When looking at the underlying table after closing the form:
If the image is pasted, it shows "Picture" as the value in the field
If the image is put in via Insert Object and it is unlinked, it shows
"Package"
When I look at the "Bound Object Frame", I see no difference in values. I
see identical images when viewing the form.
My initial take on it is if the image won't change, go ahead and paste it
in. If the document may change, then it should be linked.
Is there a preferred method?What program are you using?
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dkline" <Dkline001@.comcast.net> wrote in message
news:%23v1xUqpHFHA.1860@.TK2MSFTNGP15.phx.gbl...
>I have a form in which one of the columns will show a picture. Is there any
>difference when using the form if I paste in the image or use "Insert
>Object".
> When looking at the underlying table after closing the form:
> If the image is pasted, it shows "Picture" as the value in the field
> If the image is put in via Insert Object and it is unlinked, it shows
> "Package"
> When I look at the "Bound Object Frame", I see no difference in values. I
> see identical images when viewing the form.
> My initial take on it is if the image won't change, go ahead and paste it
> in. If the document may change, then it should be linked.
> Is there a preferred method?
>

Image - Paste into table vs. Insert Object linked or unlinked

I have a form in which one of the columns will show a picture. Is there any
difference when using the form if I paste in the image or use "Insert
Object".
When looking at the underlying table after closing the form:
If the image is pasted, it shows "Picture" as the value in the field
If the image is put in via Insert Object and it is unlinked, it shows
"Package"
When I look at the "Bound Object Frame", I see no difference in values. I
see identical images when viewing the form.
My initial take on it is if the image won't change, go ahead and paste it
in. If the document may change, then it should be linked.
Is there a preferred method?What program are you using?
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dkline" <Dkline001@.comcast.net> wrote in message
news:%23v1xUqpHFHA.1860@.TK2MSFTNGP15.phx.gbl...
>I have a form in which one of the columns will show a picture. Is there any
>difference when using the form if I paste in the image or use "Insert
>Object".
> When looking at the underlying table after closing the form:
> If the image is pasted, it shows "Picture" as the value in the field
> If the image is put in via Insert Object and it is unlinked, it shows
> "Package"
> When I look at the "Bound Object Frame", I see no difference in values. I
> see identical images when viewing the form.
> My initial take on it is if the image won't change, go ahead and paste it
> in. If the document may change, then it should be linked.
> Is there a preferred method?
>