Tuesday, 6 March 2012

Data table to bind gridview


Usercontrol

<asp:GridView ID="grd" runat="server" AutoGenerateColumns="false"  CssClass="iGActOverDue" >
<Columns>
<asp:BoundField HeaderText="Name" DataField="Name" ItemStyle-ForeColor="#000000"  HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center"/>
<asp:TemplateField>
<HeaderTemplate>
<asp:Label ID="lblheader" runat='server' Text="Joining Date"></asp:Label>
</HeaderTemplate>
<ItemTemplate>
<asp:Label ID="lbl" runat ="server" Text='<%# Eval("Joining Date", "{0:dd-M-yyyy}") %>' ForeColor="Black" ItemStyle-ForeColor="#000000" HeaderStyle-HorizontalAlign="left" ItemStyle-HorizontalAlign="Center">
</asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField HeaderText="Course" DataField="Course"   HeaderStyle-HorizontalAlign="Center" ItemStyle-ForeColor="#000000" ItemStyle-HorizontalAlign="Center"/>
<asp:BoundField HeaderText="Total Hours" DataField="Total Hours"   HeaderStyle-HorizontalAlign="Center" ItemStyle-ForeColor="#000000" ItemStyle-HorizontalAlign="Center" />
<asp:BoundField HeaderText="Completed Hours" DataField="Completed Hours"  HeaderStyle-HorizontalAlign="Center" ItemStyle-ForeColor="#000000" ItemStyle-HorizontalAlign="Center"/>
<asp:BoundField HeaderText="Total Assignments" DataField="Total Assignments"   HeaderStyle-HorizontalAlign="Center" ItemStyle-ForeColor="#000000" ItemStyle-HorizontalAlign="Center"/>
<asp:BoundField HeaderText="Completed Assignments" DataField="Completed Assignments"  HeaderStyle-HorizontalAlign="Center" ItemStyle-ForeColor="#000000" ItemStyle-HorizontalAlign="Center"/>
<asp:TemplateField>
<HeaderTemplate>
<asp:Label ID="lbltxt" Text="Email" runat="server"></asp:Label>
</HeaderTemplate>
<ItemTemplate>
<asp:Button ID="btnemail" Text="Send email" runat="server"  CssClass="ms-ButtonHeightWidth" HeaderStyle-HorizontalAlign="Center" ItemStyle-ForeColor="#000000" ItemStyle-HorizontalAlign="Center"/>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField HeaderText="Current Grade" DataField="Current Grade"  HeaderStyle-HorizontalAlign="Center" ItemStyle-ForeColor="#000000" ItemStyle-HorizontalAlign="Center"/>
</Columns>
</asp:GridView>


Code
 public void gridshow()
        {
            try
            {
                DataTable dt = new DataTable();
                dt.Columns.Add("Name", typeof(string));
                dt.Columns.Add("Joining Date", typeof(DateTime));
                dt.Columns.Add("Course", typeof(string));
                dt.Columns.Add("Total Hours", typeof(int));
                dt.Columns.Add("Completed Hours", typeof(int));
                dt.Columns.Add("Total Assignments", typeof(int));
                dt.Columns.Add("Completed Assignments", typeof(int));
                dt.Columns.Add("Current Grade", typeof(string));
                dt.Rows.Add("anand raj", "3 /6/ 2012", "SharePoint", 2, 3, 4, 3,"A+");
                dt.Rows.Add(" raj", "3 / 7 / 2012", "SharePoint", 2, 3, 4, 3,"B");
                dt.Rows.Add("albert", "3 / 8 / 2012", "SharePoint", 2, 3, 4, 3,"B+");
                dt.Rows.Add("rajkumar", "3/ 9 / 2012", "SharePoint", 2, 3, 4, 3,"C");
                dt.Rows.Add("vikram", "3/ 10 / 2012", "SharePoint", 2, 3, 4, 3,"A");
                dt.Rows.Add("andrews", "3/11 / 2012", "SharePoint", 2, 3, 4, 3,"A+");
                dt.Rows.Add("stalin", "3/ 12 / 2012", "SharePoint", 2, 3, 4, 3,"C");
                dt.Rows.Add("james", "3/ 13 / 2012", "SharePoint", 2, 3, 4, 3,"B+");
                dt.Rows.Add("anand", "3 / 14 / 2012", "SharePoint", 2, 3, 4, 3,"A");
                grd.DataSource = dt;
                grd.DataBind();
            }
            catch (Exception ex)
            {
                lblerror.Text = ex.Message;
            }
         
        }

No comments:

Post a Comment