Serious Problem.......pls help

[adhikarirs]

hi Beacon..
I’ve a serious and simple problem. I want to save and retrive the picture from my sql table. I’m using VB with SQL Server.
I’ve created 2 tables, i.e. ptable,mtable
Ptable fields:
Id varchar2(5)
Photo Image

Mtable fields:
Id varchar2(5)
Name varchar2(30)

I’ve created a form on which 2 bound text boxes based on Mtable and 1 picture box to show picture of employee which is stored on other table(Ptable). My problem is:
1. if I bound picture box to the photo field then It shows error”Unable to bind to field or data member”Photo”.
2. How can I save a picture in photo field of Ptable.
3. How can I retrive an Employees picture in Photo field.

I’m attaching similar code based on Northwind database……pls try to solve my problem .. if possible write the code also…
Lots of thanks in advance….My id is: [email protected]
Adhikari….

[kirankumar]

Please go thru this code.

[Beacon]

Originally posted by adhikarirs
hi Beacon..
I’ve a serious and simple problem. I want to save and retrive the picture from my sql table. I’m using VB with SQL Server.
I’ve created 2 tables, i.e. ptable,mtable
Ptable fields:
Id varchar2(5)
Photo Image

Mtable fields:
Id varchar2(5)
Name varchar2(30)

I’ve created a form on which 2 bound text boxes based on Mtable and 1 picture box to show picture of employee which is stored on other table(Ptable). My problem is:
1. if I bound picture box to the photo field then It shows error”Unable to bind to field or data member”Photo”.
2. How can I save a picture in photo field of Ptable.
3. How can I retrive an Employees picture in Photo field.

I’m attaching similar code based on Northwind database……pls try to solve my problem .. if possible write the code also…
Lots of thanks in advance….My id is: [email protected]
Adhikari….

Top thread database forum!
Image_Library tutorial!

It explains it all!