Comments by Member 10696161 (Top 15 by date)

I've just written the line of code:

bool ok = DateTime.TryParse(datagrdStatus_order.Rows[i].Cells[8].Value, out begin_date);

and it "shouts" an error : "Argument "1": can not be converted from "object" to "string" ".

How to deal with that?

I have tested this line and inserted all of them but after that i have calling na exception:

System.NullReferenceException: "The object reference has not been set to the instance of the object."

and it shows at the code line:

cmd.Parameters.Add("@FNAME", MySqlDbType.VarChar).Value = datagrdStatus_zl.Rows[i].Cells[0].Value.ToString();

Can you help how to solve it next? I have to change from Parameters.Add to Parameters.AddWithValue?

Ok now i know what should i do next time. Thx for help! If only i don't why my question is downvoted?

But what about the solution? Have you got it?

Can you show please how to do it or code?

Thank for answer but i've tested this code and i have an error

#1582 - Incorrect parameter count in the call to native function 'TIMEDIFF'

For some help i have 10.1.37-MariaDB Version

ok, I've tried with textBox4.Text = parts[1] but it doesn't display full name with space because for example:

textBox4.Text = parts[1]

Exception -> S BOX
Reality -> S 

the System.ArgumentOutOfRangeException is called right in the line:

while (reader.Read())
            {                chart1.Series[0].Points.AddXY(reader.GetString("ORDER_NUMBER"), reader.GetDateTime("TOTAL_TIME"));            }

I've tried by UserAddedRow event:

private void dataGridView4_UserAddedRow(object sender, DataGridViewRowEventArgs e)
        {

            string name_project= e.Row.Cells[1].Value.ToString();
            int id = (int)Convert.ToInt64(e.Row.Cells[0].Value.ToString());

            MySqlConnection connection = new MySqlConnection("datasource = localhost; port = 3306; username = root; password = ");
            MySqlCommand cmd = new MySqlCommand("INSERT INTO projekt1.projects(PROJECT_NAME) VALUES(@NPROJECT_NAME);", connection);


            cmd.Parameters.Add("@ID", MySqlDbType.Int64).Value = id;

            cmd.Parameters.Add("@PROJECT_NAME", MySqlDbType.VarChar).Value = name_project;


            try
            {
                connection.Open();
                cmd.ExecuteNonQuery();
                connection.Close();

                MessageBox.Show("ok");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

but have exception in below

System.NullReferenceException: The object reference has not been set to the instance of the object. System.Windows.Forms.DataGridViewCell.Value.get returned null.”