how to do autocomplete for date alone [not with time] in textbox in required format "dd-mm-yyyy" and fetch the matching date column to display in datagriview
OLCMND3 = new OracleCommand("Select to_date(to_char(TODAYDATE, 'dd-mm-yyyy'),'dd-mm-yyyy HH:MI:SS') as TODAYDATE from TABLENAME order by NUMBER asc", CON);
DR1 = OLCMND3.ExecuteReader();
if (DR1.HasRows == true)
{
while (DR1.Read())
{
ACSCVV.Add(DR1["TODAYDATE"].ToString());
}
}
else
{
MessageBox.Show("No Data Present In The Database");
}
DR1.Close();
TypeHereTextBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
TypeHereTextBox.AutoCompleteSource = AutoCompleteSource.CustomSource;
TypeHereTextBox.AutoCompleteCustomSource = ACSCVV;