Add Events in the Calendar With the Help of ASP.NET

In this article, we will discuss the Calendar Control in ASP.Net. Here we add the Birthaday, Anniversary and Meetings in the relevant dates of the calendar. For this use these steps:

Step 1: First we create a table in the database like this:

Create table AddOccasion
(
Occasion varchar(20),
Date DateTime,
Title varchar(60),
DateOfTheday int
)

Step 2: Now we use a Calendar Control in our .aspx page:

<asp:Calendar ID="Calendar1" runat="server"
></asp:Calendar>

Step 3: After That we take Three Buttons ( one for add the BirthDay, one for add the Anniversary and one for add the meeting).

<asp:Button ID="btnBirthDay" runat="server" Text="Add Birthday"
Width="84px" />
<asp:Button ID="btnAnniversary" runat="server" Text="Add Anniversary" <asp:Button ID="btnBirthDay" runat="server" Text="Add Birthday"
onclick="btnBirthDay_Click" Width="84px" />
<asp:Button ID="btnAnniversary" runat="server" Text="Add Anniversary"
onclick="btnAnniversary_Click" />
<asp:Button ID="btnmeeting" runat="server" Text="Add Meeting" onclick="btnmeeting_Click"
/>
/>
<asp:Button ID="btnmeeting" runat="server" Text="Add Meeting" />

Here we use a TextBox which is helpful for saving the data. And set its visible property to false:

<asp:TextBox ID="TextBox1" runat="server" Visible="false"></asp:TextBox>

Here is the Output:

Step 4: After that we add another page in our project for adding the Occasion (Add Occasion.aspx).

Step 5: After that we add the controls in the (Add occasion.aspx) page like this:

<tr>
<td class="style2">
Occasion</td>

<td>
<asp:TextBox ID="txtOccasion" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td class="style2">
Date</td>
<td>
<asp:TextBox ID="txtdate" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td class="style2">
Title</td>
<td>
<asp:TextBox ID="txtTitle" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td class="style2">
</td>
<td>
<asp:Button ID="btnAdd" runat="server" Text="Add" Width="64px"
/>
<asp:Button ID="btnCancel" runat="server" Text="Cancel"
/>
</td>
</tr>

The Output Will Be:

Step 6: Now we write the code to add the Birthday in the Default.aspx page:

protected void btnBirthDay_Click(object sender, EventArgs e)
{
String a = Calendar1.SelectedDate.Date.Date.Day.ToString();
Response.Write(a);
Int32 b = Convert.ToInt32(a);

Response.Redirect("Add Occasion.aspx?Occasion=" + "Birthday"+"&DateOfTheDay="+a + "&OnDate=" + Calendar1.SelectedDate.Date.ToShortDateString());
}

Here we transfer the data on the Add Occasion.aspx page in the form of the querystring. Here we take the date of the day, which will be helpful to fetch the data.

Step 7: After that we select the date on the calendar and click the Add Birthday Button. The output will be:

public Int32 a;
protected void Page_Load(object sender, EventArgs e)
{
txtdate.Text = Request.QueryString["OnDate"];
txtOccasion.Text = Request.QueryString["Occasion"];
a = Convert.ToInt32(Request.QueryString["DateOfTheday"]);
}

Step 8: Now we write the code for the Add button:

protected void btnAdd_Click(object sender, EventArgs e)
{
SqlConnection conn1 = new SqlConnection("Data Source=localhost;Initial
Catalog=calendar;Integrated Security=SSPI");
conn1.Open();
SqlCommand sa1=new SqlCommand ("insert into AddOccasion(Occasion,Date,Title,DateOfTheday) values('" + txtOccasion.Text + "','" + txtdate.Text + "','" + txtTitle.Text + "','"+a+"')", conn1);
sa1.ExecuteNonQuery();
conn1.Close();
Response.Redirect("Default.aspx");
}

Here we save the data in the AddOccasion table. And redirect the page to the Default.aspx.

Step 9: After that we write the code for Add Anniversary and Add Meeting Button in the Default.aspx page:

protected void btnBirthDay_Click(object sender, EventArgs e)
{
String a = Calendar1.SelectedDate.Date.Date.Day.ToString();
Response.Write(a);
Int32 b = Convert.ToInt32(a);

Response.Redirect("Add Occasion.aspx?Occasion=" + "Birthday"+"&DateOfTheDay="+a + "&OnDate=" + Calendar1.SelectedDate.Date.ToShortDateString());
}
protected void btnAnniversary_Click(object sender, EventArgs e)
{
String a = Calendar1.SelectedDate.Date.Date.Day.ToString();
Response.Write(a);
Int32 b = Convert.ToInt32(a);

Response.Redirect("Add Occasion.aspx?Occasion=" + "Anniversary" + "&DateOfTheDay=" + a + "&OnDate=" + Calendar1.SelectedDate.Date.ToShortDateString());
}
protected void btnmeeting_Click(object sender, EventArgs e)
{
String a = Calendar1.SelectedDate.Date.Date.Day.ToString();
Response.Write(a);
Int32 b = Convert.ToInt32(a);

Response.Redirect("Add Occasion.aspx?Occasion=" + "Meeting" + "&DateOfTheDay=" + a + "&OnDate=" + Calendar1.SelectedDate.Date.ToShortDateString());
}

And add the data in the Database. Which we can add in Step7.

Step 10: Now we write the code for the Calendar event.

protected void Calendar1_SelectionChanged(object sender, EventArgs e)
{
String a = Calendar1.SelectedDate.Date.Date.Day.ToString();
Response.Write(a);
Int32 b = Convert.ToInt32(a);

SqlConnection conn1 = new SqlConnection("Data Source=localhost;Initial Catalog=calendar;Integrated Security=SSPI");
conn1.Open();
SqlCommand sq1 = new SqlCommand("select * from AddOccasion", conn1);
SqlDataReader dr1 = sq1.ExecuteReader();
if(dr1.Read())
{
TextBox1.Text = Calendar1.SelectedDate.Date.ToShortDateString();
conn1.Close();
dr1.Close();
conn1.Open();
SqlCommand sq2 = new SqlCommand("select Occasion,Title from AddOccasion where Date='"+TextBox1.Text+"'", conn1);
SqlDataReader dr2 = sq2.ExecuteReader();
GridView gv = new GridView();
gv.DataSource = dr2;
gv.DataBind();
form1.Controls.Add(gv);
}
}

Here we add a Gridview to show the data. By this when we click on the Date the data for this date (BirthDay, Anniversary, Meeting) will be shown in the GridView like this:

5 Comments

Join the conversation! Your thoughts help the community grow.

Rahul Sharma9y ago
I want to show a calendar to the asp.net website with few dates highlighted. I want to select these dates from database. So that i could enter dates in the database and those dates shows up in the front page of the website. any solution.
Tati Oko10y ago
How to also implement EDIT and DELETE EVENTS ?
mayur pandit11y ago
i want add text and image in simple calendar or rad calendar ,can you help me ??
John Carlo Huelar14y ago
Can I also know what codes and sql source I'll use (is it SqlDataSource or SqlLinqDataSource or SqlObjectDatasource and how can I connect it to the Calendar. Many thanks! :)
John Carlo Huelar14y agoedited
There's a problem here on this tutorial. You didn't put: using System.Configuration; using System.Data; using System.Data.SqlClient;in the codes of Add Occasion.aspx which is why some who manage to use that kind of Calendar fails. More or less it was quite a best tutorial for web developers who wanted to use a calendar events via C# :)