Hi, I could use some help regarding putting images in a dataset.
I'm developing a windows application that accesses an sql server database in another server, an sql server 2000 database. A table, tblProducts, contains a field called ProdImage with type VarChar. ProdImage contains the path of the image which is stored in the server's file system.
I need to be able to load the records of tblProducts into a dataset including the image and not just the path since I want to use the images in a report.
What is the best way to do this? Does anybody have samples I can look at? Would doing this be better in SQL server 2005?
Thanks
I'm developing a windows application that accesses an sql server database in another server, an sql server 2000 database. A table, tblProducts, contains a field called ProdImage with type VarChar. ProdImage contains the path of the image which is stored in the server's file system.
I need to be able to load the records of tblProducts into a dataset including the image and not just the path since I want to use the images in a report.
What is the best way to do this? Does anybody have samples I can look at? Would doing this be better in SQL server 2005?
Thanks