Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

How to add date in dd/MM/yyyy to mysql in asp.net?

Anonymous User 2835 11 Dec 2014

I've used an ajax calendarExtender tool and set Format to dd/MM/yyyy while inserting the date 21/12/2013 to mysql its giving error

MySqlConnection conn = new MySqlConnection(cnnstring); 
string cmdText = "INSERT INTO trydate(Dob) VALUES ('" + TextBox1.Text + "')"; 
MySqlCommand cmd = new MySqlCommand(cmdText, conn);
conn.Open();
int a = cmd.ExecuteNonQuery();
Label1.Text = "Data Saved";
TextBox1.Text = "";

please help me to overcome from this.

Ask by Anonymous User

Updated 11 Dec 2014

2 Answers

Lillian Martin 11 Dec 2014

Use DateTime.ParseExact Method to convert TextBox1.Text to a DateTime variable, and change your query to parameterized query to avoid SQL injection. Also, use using statement to make sure that conn is closed after executing cmd.ExecuteNonQuery()

DateTime dob = DateTime.ParseExact(TextBox1.Text, "dd/MM/yyyy", null); 
using (MySqlConnection conn = new MySqlConnection(cnnstring))
{
    string cmdText = "INSERT INTO trydate(Dob) VALUES (@Dob)";
 
    using (MySqlCommand cmd = new MySqlCommand(cmdText, conn))
    {
        cmd.Parameters.AddWithValue("@Dob", dob);
        conn.Open();
        int a = cmd.ExecuteNonQuery();
        Label1.Text = "Data Saved";
        TextBox1.Text = "";
    }
}

Anurag Sharma 11 Dec 2014

Try this,

string strText=TextBox1.Text
string qryStr = string.Format("{0:yyyy/MM/dd
HH:mm:ss}", Convert.ToDateTime(strText));
string cmdText = "INSERT INTO trydate(Dob) VALUES
('" + qryStr + "')";

MindStick Training

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.