Showing Date Events in ASP.Net Calendar Control

I have noticed that a number or comments are related to the Calendar1_DayRender function: "DataRow[] rows = socialEvents.Select(String.Format("EventDate >= #{0}# AND EventDate < #{1}#", e.Day.Date.ToShortDateString(), e.Day.Date.AddDays(1).ToShortDateString()));" and as far as I can see the same goes for the Calendar1_SelectionChanged function. As many others I get the exception "String was not recognized as a valid DateTime". I have tried to follow your instructions but I cannot figure out what is wrong, it simply will not compile. The environment for the error is MS VS 2017 Community edition, MSSQL 2012. The date format in the table looks like yyyy-MM-dd when viewed in SSMS. Will you be kind enough to elaborate a bit on the functions? Kind Regards :-) /A

I am getting error at socialEvent

I"m trying this code .. i hava an error in this line of String was not recognized as a valid DateTime. DataRow[] rows = socialEvents.Select(String.Format("Date >= #{0}# AND Date < #{1}#", e.Day.Date.ToShortDateString(), e.Day.Date.AddDays(1).ToShortDateString())); how to fix ..

I am geting an error "String was not recognized as a valid DataTime"

Create table Events(Eid Int Primary Key Identity,EventName Varchar(250), StartDate Date Not Null,EventDescription Varchar(250))

Protected void Calendar1_DayRender(object sender, DayRenderEventArgs e) { try { foreach (DataRow dr in ds.Tables[0].Rows) { DateTime dt = (DateTime)dr.Field<DateTime?>("StartDate"); if (e.Day.Date == dt.Date) { e.Cell.BackColor = System.Drawing.Color.LightSkyBlue; Literal ltr = new Literal(); string br = "<br/>"; ltr.Text = br + dr[0].ToString(); e.Cell.Controls.Add(ltr); } } } catch (Exception ex) { Response.Write(ex.ToString()); }

NOTE: DATASOURCE MEANS USER SQLSERVER USERNAME; INITIAL CATALOG MEANS UR DATABASE NAME;INTEGRATEDSECURITY MEANS UR PASSWORD ; NO NEED TO CONFUSE EVERY THING IS CLEAR

Hello Rajeev Ranjan Dont Put DB.CONFIG FILE ERROR U DONT KNOW ANY THING U LEARN FIRST

Hi Friends,Above Code Is Runing But Design Is Same As U Seen Above Of The Page...

Protected void Page_Load(object sender, EventArgs e) { try { using (con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConStr"].ConnectionString)) { da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand("select EventName,StartDate,EventDescription from Events ", con); da.Fill(ds); } } catch (Exception ex) { Response.Write(ex.ToString()); } }

<asp:Calendar ID="Calendar1" runat="server" BackColor="White" BorderColor="Black" Font-Names="Verdana" Font-Size="9pt" ForeColor="Black" Height="479px" Width="941px" ondayrender="Calendar1_DayRender" ToolTip="Event Calendar" Caption="Calender Application" CaptionAlign="Top" OnSelectionChanged="Calendar1_SelectionChanged" style="margin-right: 76px" BorderStyle="Solid" CellSpacing="1" FirstDayOfWeek="Sunday"> <DayHeaderStyle Font-Bold="True" Height="8pt" Font-Size="8pt" ForeColor="#333333" /> <DayStyle BackColor="#CCCCCC" /> <NextPrevStyle Font-Size="8pt" ForeColor="White" Font-Bold="True" /> <OtherMonthDayStyle ForeColor="#999999" /> <SelectedDayStyle BackColor="#66FF33" ForeColor="White" /> <TitleStyle BackColor="#333399" Font-Bold="True" Font-Size="12pt" ForeColor="White" BorderStyle="Solid" Height="12pt" /> <TodayDayStyle BackColor="#999999" ForeColor="White" /> </asp:Calendar> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"> <Columns> <asp:BoundField DataField ="EventName" HeaderText="EventName" /> <asp:BoundField DataField="StartDate" HeaderText="StartDate" /> <asp:BoundField DataField="EventDescription" HeaderText="EventDescription" /> </Columns> </asp:GridView>

Using System.Data;using System.Data.SqlClient;using System.Drawing; using System.Configuration;

Protected void Calendar1_SelectionChanged(object sender, EventArgs e) { con = new SqlConnection(constr); da = new SqlDataAdapter("Select EventName,StartDate,EventDescription From Events where StartDate='"+Calendar1.SelectedDate.ToString()+"'", con); ds = new DataSet(); da.Fill(ds); GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); }

Above WEB.CONFIG FILE IS CORRECT Please U will Put Ur Web.ConFig File In Below CommentBox?

No Need To Write AnyThing

<connectionStrings> <add name="Constr" connectionString="Data Source=Ganesh;Initial Catalog=Forms;Integrated Security=SSPI; " providerName="System.Data.SqlClient" /> </connectionStrings> <appSettings> <add key="ValidationSettings:UnobtrusiveValidationMode" value="None"/> </appSettings>

Database Design:- Same AS u Design Earlier

Protected void Calendar1_DayRender(object sender, DayRenderEventArgs e) { try { foreach (DataRow dr in ds.Tables[0].Rows) { DateTime dt = (DateTime)dr.Field<DateTime?>("StartDate"); if (e.Day.Date == dt.Date) { e.Cell.BackColor = System.Drawing.Color.LightSkyBlue; Literal ltr = new Literal(); string br = "<br/>"; ltr.Text = br + dr[0].ToString(); e.Cell.Controls.Add(ltr); } } } catch (Exception ex) { Response.Write(ex.ToString()); }

Actually This Code Is Not Running Please Correct Mistakes Day_Render Method

Its Fake Code Not Runing in My Computer I Changed According To My Web.Config File .Please Check Calender1_Render Code... And Rectify The Error.

Hey Rajeev. Im using mysql database to retrieve data from database onto the calendar. but im having the same problems as others are having. My error "Cannot perform '<' operation on MySql.Data.Types.MySqlDateTime and System.DateTime.". if you could help. Thanks

Hi Rajeev, I followed your way but I'm still getting the same issue as the others 'String was not recognized as a valid DateTime.' And yes I have my own connection string in my own web config file. Any help would be much appreciated. Thanks

Hi Rajeev , I also got the same Exception in Calendar1_DayRender(object sender, DayRenderEventArgs e) . Exception is "String was not recognized as a valid DateTime." On this Code DataRow[] rows = socialEvents.Select( String.Format( "Date >= #{0}# AND Date < #{1}#", e.Day.Date.ToShortDateString(), e.Day.Date.AddDays(1).ToShortDateString() ) ); . Please help resolve.

Thank you very much mr.Rajeev!This helped me a lot..

Hello Rajeev , i have got an Exception in Calendar1_DayRender(object sender, DayRenderEventArgs e) . Exception is "String was not recognized as a valid DateTime." On this Code DataRow[] rows = socialEvents.Select( String.Format( "Date >= #{0}# AND Date < #{1}#", e.Day.Date.ToShortDateString(), e.Day.Date.AddDays(1).ToShortDateString() ) ); . I had Followed your All Procedure as You Say. Help me !!

hey rajeev just wanna ask , how to get event description on mouse over , i tried with javascript but it is displaying on header , is their anything can we implement with mouse over .

i downloaded the code done the things as you mentioned in comments and above code but still error is displayed specific in this format("Date >= #{0}# AND Date < #{1}#" ).

jeff dzn customize the column names for the grid and increase the cell size it is defined in database. And aprt you can adjust this style sheet using css. you can use jquery model pop for displaying those events.

Awesome code. How do you customize the column names for the grid and increase the cell size? I am using the second flavor with the database. When I click on a date with events in it, the grid view shows the cells auto sizing with the data which results in squished columns.

As my suggestion : - only try to follow steps, and make itself, as i supposed you will never get any bug in ur code

As the error you have mentioned. Can you just have a look of ur code and tell me did you activate the calender_DayRender event and calender_SelectionChanged() event. if not then press f4 on the calender and double click on the both of them you will get automatically those events on the code behind. past those code there and then hit F5 ( or run the project) I hope you will not get any error. Thnx

dear Hurair Hashmi and sharmila thirumalai As i supposed you both are trying to downlaod the sample code and hiting the F5 button, and you are getting error, this is quite obvious for error, cuz i wasn't upload the web.cofig file inside it. There is only code and design.

not able to solve the same problem which sharmila thirumalai was facing... NEED HELP...

try to add degugger at every field and find the exact error, if you couldn't then i will help you

and you are getting error ??

ya I specified all the 3 fields as you said

did you specified EventDate in you table? EventDate is the the field of database which i was binding.

i'm also getting same error as above person.but i didn't try to convert dateTime into string . the error is in "EventDate >= #{0} AND EventDate < #{1}".i have specified EventDate as only date in db.while retrieving EventDate it is in datetime format but arguments are in date format . i think this is the error but not sure. pls help me to get through this and thanks for ur code.

thanks for this code, but code gives an exception "String was not recognized as a valid DateTime." please give suggestion on this. i tried for removing time part from date but still it gives same error exception.

Try to follow my steps as I mentioned and make a fresh one. Thanks

Error 1 Could not load type 'CalendarEv.Calendar'. C:\Users\admin\Documents\MyDocuments\calendarCode\Calendar.aspx 1 i download code but show the above error

Can you please post the source code of the second part of this tutorial, the connection of the database? I don't know how to create the "See the event in the calendar" link on the page. Also tips for those that have some problems: don't forget to add using System.Data;using System.Drawing;

good aticle

Nice article.....