I need to bulild a scheduling app where a user can submit a request for an appointment that then will need to be approved/modified by an admin before being added to the Activty table. Currently I have a table that stores all of the info for the request including recurrence data. I need to be able to display these "requested" appointments in a web month view. I am attempting to return the columns from the "Request" table using a stored procedure and LinqToSql methods. I have attempted to use a generic data provider in several different manners with no luck.:
1. bind to a List returned from a LinqToSql Method
2. bind to a LinqData source(which gets its data from a stored proc programmatically)
Can somebody attempt to point me in the correct direction? My month views display properly but contain no Appointments.