{"id":971,"date":"2011-07-14T17:01:41","date_gmt":"2011-07-14T21:01:41","guid":{"rendered":"http:\/\/www.iowawebnet.com\/ein\/?p=971"},"modified":"2011-07-20T11:19:36","modified_gmt":"2011-07-20T15:19:36","slug":"monthly-event-calendar-%e2%80%93-control-parameter-query","status":"publish","type":"post","link":"https:\/\/www.iowawebnet.com\/ein\/2011\/07\/monthly-event-calendar-%e2%80%93-control-parameter-query\/","title":{"rendered":"Monthly Event Calendar \u2013 Control parameter query"},"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 calander item selection change. This is suitable for deisplaying 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<\/ol>\n\n\n\n
      \"\"<\/a><\/td>\n\"\"<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
        \n
      1. Create\/re-write web.config file (download web.config file here)<\/li>\n
      2. Add New Item and name it Month-2.aspx or whatever you like<\/li>\n
      3. Import dtgrig.css (downolad dtgrid.css file here)<\/li>\n
      4. Drag calendar control from toolbox to designer<\/li>\n
      5. Double click designer and in code behind create two subs: Page_Load and Calender1_SelectionChanged<\/li>\n<\/ol>\n

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

          \n
        1. Drag \u201cEvents\u201d table from Server Explorer to designer; Configure Data Source WHERE DateFrom = Control\u00a0 – Calendar1 and add it to a SQL expression.<\/li>\n
        2. 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 calander item selection change. This is suitable for deisplaying 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":[28,17,16,32],"tags":[30,19,51,144],"class_list":["post-971","post","type-post","status-publish","format-standard","hentry","category-access","category-applications","category-net","category-ms-sql","tag-access-2","tag-asp-net","tag-calendar","tag-controls"],"_links":{"self":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/971"}],"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=971"}],"version-history":[{"count":19,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/971\/revisions"}],"predecessor-version":[{"id":1044,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/971\/revisions\/1044"}],"wp:attachment":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/media?parent=971"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/categories?post=971"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/tags?post=971"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}