Date notice in the app

Question

I’m developing a C# application in Visual Studio. In this application there is a screen that informs the amount of events that the user has today, tomorrow and the day after tomorrow (table with green header).

Follow the screen:

I need a code that compares the current date with the date registered in the database about the event and send the number of events registered for the future days.

Ex.: No day 05/08/2016 a user registered an event for today (08/08/2016) and this event was analyzed by the code and the sum of today’s events (08/08/2016) It was sent to the label.Text and so on.

In short, the code should analyze the events for three days and send the sum of events for three label.Text, current day, day after and day after the day after.

The code I refer to at the bank:

public DataTable Load(string sql)
{
    DALTexto objSqlCeServerDAL = DALTexto.GetInstance(connString); 
    objSqlCeServerDAL.Open();
    SqlCeDataAdapter dAd = new SqlCeDataAdapter(sql, objSqlCeConnection);
    dAd.SelectCommand.CommandType = CommandType.Text;
    DataSet dSet = new DataSet();
    try
    {
        dAd.Fill(dSet, "textos");
        return dSet.Tables["textos"];
    }
    catch
    {
        throw;
    }
    finally
    {
        dSet.Dispose();
        dAd.Dispose();
        objSqlCeServerDAL.Dispose();
    }
}