How to insert data in mysql database using C#

Question

string query2 = "INSERT INTO library_database.status_of_issue VALUES('";
query2 = query2 +textBox2.Text + "','";
query2 = query2 + textBox1.Text + "', CURDATE(),ADDDATE(CURDATE(), INTERVAL 14 DAY)";
cmd = new MySqlCommand(query2, con);
MySqlDataReader d1 = cmd.ExecuteReader();
MessageBox.Show("Issed...");
d1.Close();

The error comes that there is an error in sql syntax. – ASIM SHAHID Sep 10 '14 at 16:03 — ASIM SHAHID, Sep 10 '14 at 16:03

dotNET · Answer 1 · 2014-09-10T16:14:46.550

So very obvious. You're missing the ending paranthesis of VALUES. This should work:

string query2 = string.Format("INSERT INTO library_database.status_of_issue VALUES('{0}', '{1}', CURDATE(), ADDDATE(CURDATE(), INTERVAL 14 DAY))", textBox2.Text, textBox1.Text);

using(var cmd = new MySqlCommand(query2, con))
{
    if(cmd.ExecuteNonQuery() > 0)
        MessageBox.Show("Issed...");
}

Also note that INSERT, UPDATE and DELETE commands should be executed using ExecuteNonQuery().

score 0 · Accepted Answer · edited May 23 '17 at 11:59

Missing the closing parenthesys for the VALUES clause, but your query should be rewritten to avoid Sql Injection and an INSERT query is executed with ExecuteNonQuery

string query2 = @"INSERT INTO library_database.status_of_issue VALUES(@p1, @p2,
                  CURDATE(),ADDDATE(CURDATE(), INTERVAL 14 DAY))";
cmd = new MySqlCommand(query2, con);
cmd.Parameters.AddWithValue("@p1", textBox2.Text);
cmd.Parameters.AddWithValue("@p2", textBox1.Text);
int rows = cmd.ExecuteNonQuery();
if(rows > 0)
     MessageBox.Show("insert OK...");

How to insert data in mysql database using C#

2 Answers2