Lots of errors when inserting data into table

[MADGE25]

I want to insert data into my table Shelter from a form (with TextBox, DateTimePicker, Image, comboBox ...). However, my code returns me different errors.

Description of my table Shelter

Code int 4 Primary key
Category nvarchar 50
Name nvarchar 50 
NbOfAdult nvarchar 2 
NbOfKid nvarchar 2
RateOfTVA nvarchar 10 
PriceTTC int 4
Picture image
DateCreated datetime
DateModified datetime
ModifiedBy nvarchar 50

Here is my code:

private void btnOK_Click(object sender, EventArgs e)
        {
            dbShelterDataSet1.ShelterRow newShelterRow = dbShelterDataSet1.Shelter.NewShelterRow();
 
            newShelterRow.Code = Int32.Parse(tbReference.Text);
            newShelterRow.Category = cbCategory.Text;
            newShelterRow.Name = tbNameShelter.Text;
            newShelterRow.NbOfAdult = Int32.Parse(mtbNbOfAdult.Text);
            newShelterRow.NbOfKid = Int32.Parse(mtbNbOfKid.Text);
            newShelterRow.RateOfTVA = Int32.Parse(cbRateOfTVA.Text);
            newShelterRow.PriceTTC = Int32.Parse(tbLowSeasonWeekPriceTTC.Text);
            newShelterRow.Picture = t***ctures.Text;
            newShelterRow.DateCreated = dtpDateCreated.Text;
            newShelterRow.DateModified = dtpDateModified.Text;
            newShelterRow.ModifiedBy = cbModifiedBy.Text;
 
            dbShelterDataSet1.Shelter.AddShelterRow(newShelterRow);
            try
            {
                shelterTableAdapter.Update(dbShelterDataSet1.Shelter);
            }
            catch (SqlCeException exception)
            {
                MessageBox.Show("Error :\n" + exception.Message, "Error");
            }
        }

I have the following errors:

newShelterRow.Picture = t***ctures.Text;

gives

Can not implicitly convert type 'string' to 'byte []'

newShelterRow.DateCreated = dtpDateCreated.Text;

gives

Can not implicitly convert type 'string' to 'System.DateTime'

newShelterRow.DateModified = dtpDateModified.Text;

gives

Can not implicitly convert type 'string' to 'System.DateTime'

[opaper]

I have not read everything already but this concerns me

Not you?

Picture image

and you do

newShelterRow.Picture = t***ctures.Text;

[MADGE25]

Picture is the field name of my table Shelter. Picture type is an image. I put her, because when you create a table in my dbShelter.sdf. It offers the type: image.

Because I try to put the following code:

newShelterRow.Picture = t***ctures.Image ;

But I have the following error:

'System.Windows.Forms.TextBox' does not contain a definition for 'image' and no extension method 'Image' accepting a first argument of type 'System.Windows.Forms.TextBox' has been found (a directive Using or an assembly reference is missing*?)

[!const]

I have the impression that you have a learning wizard, mixing all the jars you have on hand without knowing what they contain. A TextBox is not used to contain an image. A DateTime that is not text.

Errors will be clear to me: you must convert your variables as you can tell him a picture object is equal to the text. I believe you must use the CONVERT function to change your type

[opaper]

I do not think the Convert method converts the text to image or vice versa

Before trying to convert I would first type of inventory in the database to use a form provided with controls that may be pertinent

For the picture its an image

For DateTime they are DateTimePicker.Value etc...

[MADGE25]

Thank you for your responses. I think I managed to DateTimePicker. However I have one exception:

Here is my new code:

private void btnOK_Click(object sender, EventArgs e)
        {
            dbShelterDataSet1.ShelterRow newShelterRow = dbShelterDataSet1.Shelter.NewShelterRow();
            newShelterRow.Category = cbCategory.Text;
            newShelterRow.Name = tbNameShelter.Text;
            newShelterRow.NbOfAdult = int.Parse(mtbNbOfAdult.Text);
            newShelterRow.NbOfKid = int.Parse(mtbNbOfKid.Text);
            newShelterRow.RateOfTVA = Int32.Parse(cbRateOfTVA.Text);
            newShelterRow.PriceTTC = int.Parse(tbLowSeasonWeekPriceTTC.Text);
            //newShelterRow.Picture = p***cture.Image;
            newShelterRow.DateCreated = dtpDateCreated.Value;
            newShelterRow.DateModified = dtpDateModified.Value;
            newShelterRow.ModifiedBy = cbModifiedBy.Text;
 
            dbShelterDataSet1.Shelter.AddShelterRow(newShelterRow);
            try
            {
                shelterTableAdapter.Update(dbShelterDataSet1.Shelter);
            }
            catch (SqlCeException exception)
            {
                MessageBox.Show("Error :\n" + exception.Message, "Error");
            }
        }

The exception is the following:

The exception NoNullAllowed was not handled.

The Code column is the primary key of my table Shelter. So, how do I make an autoincrement column of my code? The column 'code' does not allow nulls.