postback is confusing me

[stucker79]

I am using a control I purchased called calendar.net. I have some code in my page load event that populates that calendar with items. I currently have the code in an if not ispostback statement. I realize now that when a user navigates away from the page and then goes back to it, that code fires again. This is causing my calendar to get populated again. What is the best way to ensure my calendar doesn't repopulate?

 

[stucker79]

I forgot to mention that when I debug this, it almost seems to be cached somehow. I say this because when I stop and restart the project, it will show up with duplicate entries on first page load.

 

[BoulderBum]

Do you put the data into a database or something on each visit? Does the control have built-in caching features?

If not, please post the code block where the calendar gets populated and we can take a look.

 

[stucker79]

I'm not sure if the control has built in caching, i looked in there help file and couldn't find anything. Here's my code:

If Not IsPostBack Then

SqlConn.ConnectionString = ConfigurationSettings.AppSettings("SqlConn")

'Populate Calendar

Dim daGetTitle As SqlDataAdapter = New SqlDataAdapter
Dim cmdGetTitle As SqlCommand = New SqlCommand
cmdGetTitle.Connection = SqlConn
daGetTitle.SelectCommand = cmdGetTitle
cmdGetTitle.CommandType = CommandType.StoredProcedure
cmdGetTitle.CommandText = "spGetTitle"

DataCmp.daCourse.Fill(DataCmp.DsTraining, "Course")
DataCmp.daCourseTopic.Fill(DataCmp.DsTraining, "CourseTopic")
daGetTitle.Fill(DataCmp.DsTraining, "spGetTitle")
DataCmp.daInstructor.Fill(DataCmp.DsTraining, "Instructor")
DataCmp.daLocation.Fill(DataCmp.DsTraining, "Location")
DataCmp.daCourseInstance.Fill(DataCmp.DsTraining, "CourseInstance")

CalendarCtrl.DataSource = DataCmp.DsTraining
CalendarCtrl.DataMember = "spGetTitle"

CalendarCtrl.DataBind()

End Sub