I am displaying Event dates from SQL table on Calendar Control in ASP.NET. Also, I have GridView Control which shows event details when certain date is clicked on calendar control. But I have a problem as not all dates are displaying properly.
Strangly enough only dates which have same month and day date are displayed. For example:
It shows ok dates such as 08/08/2010, 09/09/2010, 10/10/2010 etc. If I click on the date which in SQL table exists as 11/25/2010 or 12/15/2010 etc (no matching month/day numbers) it shows error message saying: "System.Data.SqlClient.SqlException: Conversion failed when converting date and/or time from character string."
Follwoing is my code: using System;
public partial class Test_Calendar : System.Web.UI.Page
DataSet ds = new DataSet();
private void Page_Load(object sender, System.EventArgs e)
strConn = "Data Source=mydatasource;Initial Catalog=DBname;Persist Security I
View Complete Post