Code:
 //DateTime date= DateTime.Parse(maskedSearch.Text);
                            sqlConnection.Open();
                            sqlDataAdapter = new SqlDataAdapter("SELECT * FROM Transactions WHERE date='" +Convert.ToDateTime(maskedSearch.Text) + "'", sqlConnection);
                            dataTable = new DataTable();
                            dataTable.Locale = System.Globalization.CultureInfo.InvariantCulture;
                            sqlDataAdapter.Fill(dataTable);
                            dataGridViewSearch.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
                            dataGridViewSearch.ReadOnly = true;
                            dataGridViewSearch.DataSource = dataTable;
                            dataGridViewSearch.Visible = true;
Please i want to select based on the date entered into a maskedTextbox but it's showing error, what can I do to achieve this. Thanks. The error message is:
"Conversion failed when converting date and / or time from character string"