search envelope-o feed check
Home Unanswered Active Tags New Question
user comment-o

Event Calendar and ModalPopupExtender

Related article: Event Calendar and ModalPopupExtender (C#, ASP.NET)
Asked by Tolga
8 years ago.

I wonder where is the "DbSelectEvents" function in your tutorial?

Answer posted by Dan Letecky [DayPilot]
8 years ago.

It's omitted from the tutorial text for brevity but you can find it in the downloadable project (in Default.aspx.cs).

This is the source code:

private DataTable DbSelectEvents(DateTime start, DateTime end)
{
    SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [event] WHERE NOT (([eventend] <= @start) OR ([eventstart] >= @end))", ConfigurationManager.ConnectionStrings["daypilot"].ConnectionString);
    da.SelectCommand.Parameters.AddWithValue("start", start);
    da.SelectCommand.Parameters.AddWithValue("end", end);

    DataTable dt = new DataTable();
    da.Fill(dt);

    return dt;
}
Answer posted by Tolga
8 years ago.

thank you sir I am grateful

This question is more than 1 months old and has been closed. Please create a new question if you have anything to add.