private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
{
DateTime Date;
bool isDate = DateTime.TryParseExact(dtpData.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture,
DateTimeStyles.None, out Date);
if (isDate)
{
DataTable dt = SqlConn.Read(SqlGenerate.SelecttDataTask(dtpData.Text));
if (dt.Rows.Count > 0)
{
dtpData.Tag = dt.Rows[0][0];
dt = SqlConn.Read(SqlGenerate.SelectTasks(Convert.ToInt32(dtpData.Tag)));
// dgvSenhas.DataSource = dt;
foreach (DataRow r in dt.Rows)
{
int index = dgvTask.Rows.Add();
dgvTask.Rows[index].Cells["clnData"].Value = r["Data"].ToString().Replace("-", "/");
dgvTask.Rows[index].Cells["clnTitulo"].Value = r["Titulo"];
dgvTask.Rows[index].Cells["clnHora"].Value = r["Hora"];
dgvTask.Rows[index].Cells["clnDescricao"].Value = r["Descricao"];
dgvTask.Rows[index].Cells["clnIdDesc"].Value = r["id"];
dtpData.Tag = r["IdTask"];
}
}
else
{
dgvTask.Rows.Clear();
dtpData.Tag = null;
}
}
else
{
dtpData.Tag = null;
dgvTask.Rows.Clear();
}
}