Member 13604810 Ответов: 1

Как проверить, если дата, которую я выбираю из date time picker, больше, чем дата из моей базы данных SQL


 private void btn_search_Click(object sender, EventArgs e)
        {
            
            SqlConnection conn = new SqlConnection("Data Source=......;Initial Catalog=Innux;Persist");
conn.Open();
            SqlDataAdapter SDA = new SqlDataAdapter("select dbo.Alteracoes.Data, dbo.Funcionarios.numero as no, dbo.Funcionarios.nome, DATEPART(hour, Falta) AS faltas, DATEPART(hour, Coluna2) AS  horasextra  from dbo.Alteracoes inner join dbo.Funcionarios on dbo.Alteracoes.IDFuncionario = dbo.Funcionarios.IDFuncionario inner join dbo.Departamentos on dbo.Funcionarios.IDDepartamento = dbo.Departamentos.IDDepartamento WHERE Data = '" + dateTimePicker1.Value.ToString("yyyy/MM/dd") + "'", conn);

            DataSet dt = new DataSet();

            SDA.Fill(dt, "dbo.Alteracoes.Data");
            dataGridView1.DataSource = dt.Tables["dbo.Alteracoes.Data"];
            conn.Close();
        }

        private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
        {
          

        }

This code search for the data  from the date i choose. 
And now i just want cheack if the date selected is < from (select u_recpica from e_industrial.dbo.e1) this table. If true show the data, if not is not valid  


Что я уже пробовал:

<pre>
 private void btn_search_Click(object sender, EventArgs e)
        {
            
            SqlConnection conn = new SqlConnection("Data Source=......;Initial Catalog=Innux;Persist");
conn.Open();
            SqlDataAdapter SDA = new SqlDataAdapter("select dbo.Alteracoes.Data, dbo.Funcionarios.numero as no, dbo.Funcionarios.nome, DATEPART(hour, Falta) AS faltas, DATEPART(hour, Coluna2) AS  horasextra  from dbo.Alteracoes inner join dbo.Funcionarios on dbo.Alteracoes.IDFuncionario = dbo.Funcionarios.IDFuncionario inner join dbo.Departamentos on dbo.Funcionarios.IDDepartamento = dbo.Departamentos.IDDepartamento WHERE Data = '" + dateTimePicker1.Value.ToString("yyyy/MM/dd") + "'", conn);

            DataSet dt = new DataSet();

            SDA.Fill(dt, "dbo.Alteracoes.Data");
            dataGridView1.DataSource = dt.Tables["dbo.Alteracoes.Data"];
            conn.Close();
        }

        private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
        {
          

        }

This code search for the data  from the date i choose. 
And now i just want cheack if the date selected is < from (select u_recpica from e_industrial.dbo.e1) this table. If true show the data, if not is not valid 

1 Ответов

Рейтинг:
1

Jaken Herman

Видеть DateTime.Compare документация

- значение datetime.Метод Сравнения (DateTime, DateTime) (System)[^]

Использование заключается в следующем, в вашем случае:

if (DateTime.Compare(date1, date2) < 0) 
{
 //show data
}
else 
{
  //not valid
}