<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" Height="50px" EmptyDataText="No Records Found" Width="885px"> <Columns> <asp:TemplateField > <ItemTemplate> <div class="gridcolstyle"> <asp:Label ID="lblfid" runat="server" CssClass="labelstyle" Text='<%# bind("Sr") %>'></asp:Label> </div> </ItemTemplate> </asp:TemplateField> <asp:TemplateField > <ItemTemplate> <div class="gridcolstyle"> <asp:Label ID="lblfid" runat="server" CssClass="labelstyle" Text='<%# bind("Staffname") %>'></asp:Label> </div> </ItemTemplate> </asp:TemplateField> <asp:TemplateField > <ItemTemplate> <div class="gridcolstyle"> <asp:Label ID="lblfid" runat="server" CssClass="labelstyle" Text='<%# bind("Exps1") %>'></asp:Label> </div> </ItemTemplate> </asp:TemplateField> <asp:TemplateField > <ItemTemplate> <div class="gridcolstyle"> <asp:Label ID="lblfid" runat="server" CssClass="labelstyle" Text='<%# bind("Exps2") %>'></asp:Label> </div> </ItemTemplate> </asp:TemplateField> <asp:TemplateField > <ItemTemplate> <div class="gridcolstyle"> <asp:Label ID="lblfid" runat="server" CssClass="labelstyle" Text='<%# bind("Exps2") %>'></asp:Label> </div> </ItemTemplate> </asp:TemplateField> <asp:TemplateField > <ItemTemplate> <div class="gridcolstyle"> <asp:Label ID="lblfid" runat="server" CssClass="labelstyle" Text='<%# bind("Exps2") %>'></asp:Label> </div> </ItemTemplate> </asp:TemplateField> <asp:TemplateField > <ItemTemplate> <div class="gridcolstyle"> <asp:Label ID="lblfid" runat="server" CssClass="labelstyle" Text='<%# bind("Exps3") %>'></asp:Label> </div> </ItemTemplate> </asp:TemplateField> <asp:TemplateField > <ItemTemplate> <div class="gridcolstyle"> <asp:Label ID="lblfid" runat="server" CssClass="labelstyle" Text='<%# bind("Exps4") %>'></asp:Label> </div> </ItemTemplate> </asp:TemplateField>
string str1 = "select * from ExpenseTrans"; DataTable dt1 = db.GetDataTable(str1); if (dt1.Rows.Count > 0) { GridView1.DataSource = dt1; GridView1.DataBind(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)