Description:
ASP.NET Toolbox calendar control which use control parameter to query db records and display event(s) on calendar item selection change. This is suitable for displaying events on PostBack call on the same page.
Elements:
- Events.mdb / or MS SQL
- Web.config
- Month-2.aspx
- Month-2.aspx.vb
- Dtgrid.css
Method:
- Create table Events (Id [primary key – AutoNumber], Event [Text], DateFrom [Date/Time], DateTo[Date/Time].
- Enter some data in the table
- Create/re-write web.config file (download web.config file here)
- Add New Item and name it Month-2.aspx or whatever you like
- Import dtgrig.css (downolad dtgrid.css file here)
- Drag calendar control from toolbox to designer
- Double click designer and in code behind create two subs: Page_Load and Calender1_SelectionChanged
- Redirect page to your liking (highlighted). In this case I redirected hit to a same page and I am using query string to display record(s) below the calendar. You can use new page, pop-up window or jQuery to call data
- Drag “Events” table from Server Explorer to designer; Configure Data Source WHERE DateFrom = QueryString – dd (querystring field value) and add it to a SQL expression.
- Configure css property for your calendar and grid view and you are good to go.
 |
 |
