Convert a date into yyyy-dd-mm format to dd-mm-yyyy

Question

I’m trying to do a search in my database where the goal is to search between two dates entered by the user, and that it shows me all the values that are in this date range, but I’m not able to get the date on texbox because it gives format error. I want to present the search result in a Gridview

MySqlDataAdapter da = new MySqlDataAdapter("SELECT idConduta,valor_Lido FROM valores_conduta WHERE data_Leitura BETWEEN " + txtDataInicio.Text + " AND " + txtDataInicio.Text + "", conn);

 da.SelectCommand.CommandType = CommandType.Text;

 DataSet ds = new DataSet();//definir o objecto dadaset (ds)

 //preencher os dados
 da.Fill(ds);
 GridView1.DataSource = ds;
 GridView1.DataBind();

Answer 1

You can use the .ToString("dd-MM-yyyy") on your date (must be a valid date), leaving:

MySqlDataAdapter da = new MySqlDataAdapter("SELECT idConduta,valor_Lido FROM valores_conduta WHERE data_Leitura BETWEEN " + txtDataInicio.Text.ToString("dd-MM-yyyy") + " AND " + txtDataInicio.Text.ToString("dd-MM-yyyy")** + "", conn);

Or you can convert the date before your query:

DateTime dt = DateTime.ParseExact(txtDataInicio.Text, "yyyy-dd-mm", 
                                  CultureInfo.InvariantCulture);
dt.ToString("dd-MM-yyyy");

And you use the variable dt in your consultation.