Hello! any expert can help me. Please.
I'm design a form with click Search button to search date and display data in datagridview. but when I set my access database OTDate column as Date, It will cause data mismatch problem. however, set OTDate column as Text is fine. But it will difficult when make crystal report sorting by month or year.
my date format is short date time. dd/MMM/yy
this is code:
private void btnSearch_Click(object sender, EventArgs e)
{
string sql= "SELECT * FROM OT where OTDate ='" + dtpDate.Text + "'";
OleDbConnection connection = new OleDbConnection(ConnectionString);
connection.Open();
sCommand = new OleDbCommand(sql, connection);
sAdapter = new OleDbDataAdapter(sCommand);
sBuilder = new OleDbCommandBuilder(sAdapter);
sDs = new DataSet();
sAdapter.Fill(sDs, "OT");
sTable = sDs.Tables["OT"];
connection.Close();
dataGridView1.DataSource = sDs.Tables["OT"];
dataGridView1.ReadOnly = true;
save_btn.Enabled = false;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
}