date format yyyy/MM/dd

hi,

Are you pass your UI date to query? how?

suppose you are writing query and execute it using command or adaper than try following...

using (SqlCommand command = new SqlCommand(
  "SELECT * FROM table1 WHERE Date = @Date", connection))
     {
DateTime dt;
DateTime dt;
            DateTime.TryParseExact("your date", "dd/MM/yyyy", new System.Globalization.CultureInfo("en-US"), System.Globalization.DateTimeStyles.None, out dt);
  //
  // Add new SqlParameter to the command.
  //
  command.Parameters.Add(new SqlParameter("Date", dt));
  //
  // Read in the SELECT results.
  //
  SqlDataReader reader = command.ExecuteReader();
  while (reader.Read())
  {
  }
  }

hope this will help you.