Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • How to bind all dates of month on GridView Header cell in .net

    @gaurav.gautam
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 1
    • 0
    • 0
    • 0
    • 3.48k
    Comment on it

    Hello all,

    Working with ASP.NET, we wanted to print all the dates of months on the Header cell of GridView based on current month and year dynamically from code behind which can be changes later on by selecting different month and year from the two Dropdownlists provided on the UI.

    To do that we have following code packet :

    In our ASPX page we have :

    1. <%@ Page Title="" Language="C#" AutoEventWireup="true"CodeFile="Default.aspx.cs" Inherits="_Default" %>
    2.  
    3. <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
    4. <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
    5.     <div style="border-top: 1px Dotted Grey; border-bottom: 1px Dotted Grey; padding: 7px; width: 60%; margin: 0 auto;">
    6.         <table width="100%">
    7.             <tr>
    8.                 <td>Select Month
    9.                 </td>
    10.                 <td>
    11.                     <asp:DropDownList ID="ddlMonth" runat="server" OnSelectedIndexChanged="ddlOnChange" AutoPostBack="true">
    12.                         <asp:ListItem Value="1">January</asp:ListItem>
    13.                         <asp:ListItem Value="2">February</asp:ListItem>
    14.                         <asp:ListItem Value="3">March</asp:ListItem>
    15.                         <asp:ListItem Value="4">April</asp:ListItem>
    16.                         <asp:ListItem Value="5">May</asp:ListItem>
    17.                         <asp:ListItem Value="6">June</asp:ListItem>
    18.                         <asp:ListItem Value="7">July</asp:ListItem>
    19.                         <asp:ListItem Value="8">August</asp:ListItem>
    20.                         <asp:ListItem Value="9">September</asp:ListItem>
    21.                         <asp:ListItem Value="10">October</asp:ListItem>
    22.                         <asp:ListItem Value="11">November</asp:ListItem>
    23.                         <asp:ListItem Value="12">December</asp:ListItem>
    24.                     </asp:DropDownList>
    25.                 </td>
    26.                 <td>Department Name
    27.                 </td>
    28.                 <td>
    29.                     <asp:DropDownList ID="ddlYear" runat="server" OnSelectedIndexChanged="ddlOnChange" AutoPostBack="true">
    30.                         <asp:ListItem Value="2010">2010</asp:ListItem>
    31.                         <asp:ListItem Value="2011">2011</asp:ListItem>
    32.                         <asp:ListItem Value="2012">2012</asp:ListItem>
    33.                         <asp:ListItem Value="2013">2013</asp:ListItem>
    34.                         <asp:ListItem Value="2014">2014</asp:ListItem>
    35.                         <asp:ListItem Value="2015">2015</asp:ListItem>
    36.                         <asp:ListItem Value="2016">2016</asp:ListItem>
    37.                         <asp:ListItem Value="2017">2017</asp:ListItem>
    38.                         <asp:ListItem Value="2018">2018</asp:ListItem>
    39.                         <asp:ListItem Value="2019">2019</asp:ListItem>
    40.                         <asp:ListItem Value="2020">2020</asp:ListItem>
    41.                     </asp:DropDownList>
    42.                 </td>
    43.             </tr>
    44.         </table>
    45.     </div>
    46.     <asp:Panel ID="pnlros" runat="server" Visible="false">
    47.         <div style="width: 99.9%; overflow-x: scroll; margin-top: 5px;">
    48.             <asp:GridView ID="GridView" runat="server" BackColor="White">
    49.                 <Columns>
    50.                     <asp:TemplateField HeaderText="Sr&#95;No.">
    51.                         <ItemTemplate>
    52.                             <center><asp:Label ID="lblsr" runat="server" Text='<%#Container.DataItemIndex + 1 %>'></asp:Label></center>
    53.                         </ItemTemplate>
    54.                     </asp:TemplateField>
    55.                 </Columns>
    56.             </asp:GridView>
    57.         </div>
    58.     </asp:Panel>
    59. </asp:Content>

    In C# we Have:

    1. using System;
    2. using System.Collections.Generic;
    3. using System.Linq;
    4. using System.Web;
    5. using System.Web.UI;
    6. using System.Web.UI.WebControls;
    7. using System.Collections;
    8. using System.Globalization;
    9.  
    10. public partial class _Default : System.Web.UI.Page
    11. {
    12.     CultureInfo provider = CultureInfo.CreateSpecificCulture("en-US");
    13.     protected void Page&#95;Load(object sender, EventArgs e)
    14.     {
    15.         binddropdown();
    16.         if (!IsPostBack)
    17.         {
    18.             string currentMonth = DateTime.Now.ToString("MMMM");
    19.             ddlMonth.SelectedIndex = ddlMonth.Items.IndexOf(ddlMonth.Items.FindByText(currentMonth));
    20.             string currentYear = DateTime.Now.ToString("YYYY");
    21.             ddlYear.SelectedIndex = ddlYear.Items.IndexOf(ddlYear.Items.FindByText(currentYear));
    22.             bindGrid();
    23.         }
    24.     }
    25.  
    26.  
    27.     protected void bindGrid()
    28.     {
    29.         DataTable dt = new DataTable();
    30.         int j = 0;
    31.         int year = Convert.ToInt32(ddlYear.SelectedValue.ToString());
    32.         int month = Convert.ToInt32(ddlMonth.SelectedValue.ToString());
    33.         DateTime current = new DateTime(year, month, 1);
    34.         string monthstr = current.ToString("MM", CultureInfo.InvariantCulture);
    35.         DateTime next = current.AddMonths(1);
    36.         int days = (next - current).Days;
    37.         for (int i = 1; i <= days; i++)
    38.         {
    39.             if (i < 10)
    40.             {
    41.                 dt.Columns.Add("0" + i + "/" + monthstr + "/" + year);
    42.             }
    43.             else
    44.             {
    45.                 dt.Columns.Add(i + "/" + monthstr + "/" + year);
    46.             }
    47.         }
    48.         GridView1.DataSource = dt;
    49.         GridView1.DataBind();
    50.     }
    51.  
    52.     protected void ddlOnChange(object sender, EventArgs e)
    53.     {
    54.         bindGrid();
    55.     }
    56.  
    57. }
    How to bind all dates of month on GridView Header cell in .net Show dates on GridView Header in .Net
    Comment on it

 1 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Reset Password
Fill out the form below and reset your password: