Ok, first, what I wanna achieve:
I have a calendar, and a MS SQL database where each records has a date-field. I want to group all these records based on the dates, so I can read all dates from the database.
Then I want these dates to show as bold on my calendar.
I've tried something like this, but I'm probably a bit far out...
All help would be appreciated!
protected void DayRender(Object source, DayRenderEventArgs e)
{
string constr =
"Data Source=HOSTNAME;Initial " +
"Catalog=DATABASE;User Id=USER;Password=PASSWORD;";
string str_select = "SELECT picDate, userID FROM pictures GROUP BY picDate, userID";
SqlConnection con = new SqlConnection(constr);
if (con.State == ConnectionState.Closed)
con.Open();
SqlCommand mySqlCommand = new SqlCommand(str_select, con);
SqlDataReader mySqlDataReader = mySqlComma ...
Go to the complete details ...