How can i insert events dyanamically in a calendar?

Question

i have a table in my database with the columns "Date,Event". i want bind the event based on the date.i try this code.i find some mistakes.please help me.

 

 

 

 

foreach (DataRow r in ds.Tables[0].Rows)
{
DateTime dt = r.Field<DateTime>("Date");

if (e.Day.Date == dt.Date)
{


Label lbl = new Label();


lbl.Text = r.Field<string>("Event");



}
}