Insert date into a database

[rapo]

I'm using dotconnect with C# in VS2010 and I want to insert into a mysql database,5 strings that are from some textboxes and the date that is from a DateTimePicker. But I receive an error.
This is my code:

Code: Select all

public void SetMyCustomFormat()
        {
            dtpAdaugare.CustomFormat = "yyyy-MM-dd";
        }

        private void btAdd_Click(object sender, EventArgs e)
        {
            SetMyCustomFormat();
            conexSQLObs.Open();
            comandaSQLObs.CommandText = "insert into observations(camera,name,mac,others,observations,Date) values(?,?,?,?,?,?)";
            comandaSQLObs.Parameters.Add("param1", tbCam.Text+tbLit.Text.ToUpper());
            comandaSQLObs.Parameters.Add("param2", cbPersoane.Text);
            comandaSQLObs.Parameters.Add("param3", tbmac.Text);
            comandaSQLObs.Parameters.Add("param4", tbAltele.Text);
            comandaSQLObs.Parameters.Add("param5", rtObs.Text);
            comandaSQLObs.Parameters.Add("param6", dtpAdaugare);
            comandaSQLObs.Connection = conexSQLObs;
            comandaSQLObs.ExecuteNonQuery();
            conexSQLObs.Close();
            this.Close();
        }

I receive this error:
Incorrect date value: '' for column 'Dates' at row 1
Dates is the field from the database.

[Zero-G.]

Hey

Is it possible, that you have forgotten something?

Your postetd the code

Code: Select all

dtpAdaugare

But I think, this should be something like:

Code: Select all

dtpAdaugare.Value

Hope this helps.

[Shalex]

Zero-G, thank you for your comments.

Rapo, if Zero-G's advice doesn't help, make sure that dtpAdaugare contains a value that is valid for MySQL's DATE.

Try to find out the reason of the problem with dbMonitor:
http://www.devart.com/dbmonitor/dbmon3.exe
http://www.devart.com/dotconnect/mysql/ ... nitor.html

Otherwise, send us a test project with the DDL/DML script to reproduce the issue in our environment. Also specify the versions of your dotConnect for MySQL (the Tools > MySQL > About menu of Visual Studio) and MySQL Server.