[jagatworld]

Hi all,

I need some help for the following senario:

I have a database in SQL Express :

-------------------------------------------------------
CNO - Candidate Number - integer
Name - Candidate Name - varchar(50)
DOB - Date of Birth - Datetime
Photo - Candidate Image - image
-------------------------------------------------------


Now, i have created a connection and a new data source.
On draging and dropping a table from datasources, (detailed view)

we have the following in the form:

• dataset
  
• table adapter
  
• bindingsource
  
• bindinginsource navigator
  
• Binded Controls
  
• Textbox
  
• Textbox
  
• DatetimePicker
  
• Picturebox

on the form

Now when we run the form, we can create new records, edit existing, or delete any. (without the image datatype)

But when there is an image datatype,
how to handle it?

how can i upload a new photo to this image box when creating new record?
how to edit this picture column and other things.

Please help me in this situation.

Regards.

This post has been edited by jagatworld: 04 June 2008 - 04:54 AM

[Jayman]

You would be better off storing the images in a folder and then simply storing the path to the image in the database. This is by far the most effective solution to your issue.

But if you really want to store the image in the database, then you can find a tutorial here.