{"id":1019,"date":"2011-07-14T17:45:21","date_gmt":"2011-07-14T21:45:21","guid":{"rendered":"http:\/\/www.iowawebnet.com\/ein\/?p=1019"},"modified":"2011-07-21T17:25:34","modified_gmt":"2011-07-21T21:25:34","slug":"monthly-event-calendar-%e2%80%93-query-string-parameter","status":"publish","type":"post","link":"https:\/\/www.iowawebnet.com\/ein\/2011\/07\/monthly-event-calendar-%e2%80%93-query-string-parameter\/","title":{"rendered":"Monthly Event Calendar \u2013 Query String Parameter"},"content":{"rendered":"

Description: <\/strong><\/p>\n

ASP.NET Toolbox calendar control which use control parameter<\/strong> 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<\/em><\/strong>.<\/p>\n

Elements:<\/strong><\/p>\n

    \n
  1. Events.mdb \/ or MS SQL<\/li>\n
  2. Web.config<\/li>\n
  3. Month-2.aspx<\/li>\n
  4. Month-2.aspx.vb<\/li>\n
  5. Dtgrid.css<\/li>\n<\/ol>\n

    Method:<\/strong><\/p>\n

      \n
    1. Create table Events (Id [primary key \u2013 AutoNumber], Event [Text], DateFrom [Date\/Time], DateTo[Date\/Time].<\/li>\n
    2. Enter some data in the table<\/li>\n\n\n\n
      \"\"<\/a><\/td>\n\"\"<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    3. Create\/re-write web.config file (download web.config file here)<\/li>\n
    4. Add New Item and name it Month-2.aspx or whatever you like<\/li>\n
    5. Import dtgrig.css (downolad dtgrid.css file here)<\/li>\n
    6. Drag calendar control from toolbox to designer<\/li>\n
    7. Double click designer and in code behind create two subs: Page_Load and Calender1_SelectionChanged<\/li>\n

      \"\"<\/a><\/p>\n

    8. 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<\/li>\n
    9. Drag \u201cEvents\u201d table from Server Explorer to designer; Configure Data Source WHERE DateFrom = QueryString \u2013 dd (querystring field value) and add it to a SQL expression.<\/li>\n
    10. Configure css property for your calendar and grid view and you are good to go.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

      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 \u2013 AutoNumber], Event [Text], […]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,16],"tags":[30,19,51],"class_list":["post-1019","post","type-post","status-publish","format-standard","hentry","category-applications","category-net","tag-access-2","tag-asp-net","tag-calendar"],"_links":{"self":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/1019"}],"collection":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/users\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/comments?post=1019"}],"version-history":[{"count":23,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/1019\/revisions"}],"predecessor-version":[{"id":1053,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/1019\/revisions\/1053"}],"wp:attachment":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/media?parent=1019"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/categories?post=1019"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/tags?post=1019"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}