string bugunku_randevu = "declare @bas datetime; "
            + "declare @son datetime; "
            + "set @bas=CONVERT(datetime,Convert(varchar(10),GETDATE(),102)+' 00:00:00'); "
            + "set @son=CONVERT(datetime,Convert(varchar(10),GETDATE(),102)+' 23:59:59'); "
            + @"select COUNT(durum) from liste where tarih between @bas And @son AND durum !='Tamamlandı'; ";

            SqlCommand com2 = new SqlCommand(bugunku_randevu, con);
            con.Open();
            sayi = Convert.ToInt32(com2.ExecuteScalar());
            label1.Text = label1.Tag + sayi.ToString();
            con.Close();