visual studio 2010 ultimate

Hi, i dont really know where to start, i have a access database and a column called license_Doc that is type of 'Attachment' what i need is that col will hold 'embed' a word document that is related to the doctor's or staff's ID number or name or watever, im using visual studio 2010 ultimate, vb.net, i load the datagridview and shows everything but that license_doc items, its empty!!! but from access i can open it and it will show me which attachment to open and so on, how can i put that value into a datagrid view, be it a picture or a word document so i can double click and that document will show (document in the database not linked, so wen i move me database i still have everything), im so sorry i got no code to begin with, because i do not know where to start or look even google does not have much info!!!
thanks
ahashashAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NorieVBA ExpertCommented:
What type of field is is the licence_doc in?

Is it a multivalue field?
0
ahashashAuthor Commented:
no its just a column in access and type is attachment not text or date, but if i add attachment i can add more than one attachment, in access its fine, but in visual studio its not showing in the datagridview, actually it just shows strange characters, or says bytes.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

ahashashAuthor Commented:
tried but that link shows c sharp code and not really related to my issue, thanks though it was informative, the thing is im sure there is a simple way that im pretty sure i can do from the ide tools itself but im really lost

thanks stephan
0
NorieVBA ExpertCommented:
So the type of the field is attachment and it can have multiple items, so it's a multi-valued attachment field?

You can only have one value in a 'cell' in a gridview as far as I know, and I don't think you can have documents.

It's not only in VB.NET this is a problem.

The only thing I can thing of you doing, and keeping everything in the gridview, would be to create a list of the paths/filenames of the attachments for each record and display that in the gridview.

Or have a small listbox that get's populated with the same information (path/file) of a record's attachments when it's selected in the gridview.

With that you could allow the user to select a document from the listbox and have it opened/displayed/whatever.
0
Stephan_SchrandtCommented:
The attachment datatype holds a recordset object as content type. I think you need a link to the dao to get the content of this field. Please see the last comment on http://stackoverflow.com/questions/779211/programmatically-managing-microsoft-access-attachment-typed-field-with-net

A c# to vb.net converter can be found here:
http://www.developerfusion.com/tools/convert/csharp-to-vb/

The management of an attachment field is an internal msaccess mechanism, you won't get it to work with any wizard that's included in visual studio. You have to add a nested gridview or datalist in the column you want to show the files and fill it programmatically. I don't have much experience with the interop types, so I don't know if they support databinding.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ahashashAuthor Commented:
ok i will try out and let u guys know how it goes
thank u so much for ur help
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.