My Date Format in DGV Table is Messed up any idea how to fix it? – Mysql

You will never get it right if you try to post a string for searching over a column of type date. Instead you should use parameters to avoid SQL Injection and to avoid parsing problems on the string passed to the database.

First you need to check if the input is indeed a datetime value. (the exact format to pass at the TryParseExact depends on your current inputs)

if (!DateTime.TryParseExact(txtSearch.Text, "MM/dd/yyyy HH.mm", CultureInfo.CurrentUICulture,
             DateTimeStyles.None, out DateTime searchedDate)
      
    ... not a date, display error, return....        

// Prepare the sql command avoiding string concatenations but
// using parameters placeholders.
cm = new MySqlCommand(@"SELECT OrderID, OrderDate, CustomerID,  
                        Username, ProductID, Qty, Price, TotalAmount  
                        FROM ordertb 
                        WHERE OrderDate = @searchedDate", con);

 // Add the parameter and its value. Note that we will require 
 // a parameter of type date and just the date part of the datetime variable.  
 cm.Parameters.Add("@searchedDate", MySqlDbType.Date).Value = searchedDate.Date;
 .... execute the query....

And to set the format for a specific DataGridView column use
(for example the third column)

dataGrid.Columns[2].DefaultCellStyle.Format = "MM/dd/yyyy";

Finally, if your column OrderDate stores also the time, then you should use a sligthly different WHERE condition

....
WHERE OrderDate >= @startDate and OrderDate < @endDate", con);

cm.Parameters.Add("@startDate", MySqlDbType.Date).Value = searchedDate.Date;
cm.Parameters.Add("@endDate", MySqlDbType.Date).Value = searchedDate.Date.AddDays(1);