How to add footer with label in dynamically created gridview in ASP.NET

See more:

C#3.5

actually i created grid dyanamically all clumns are came from database .now i want to display sum of column values in footer labes

What I have tried:

<asp:GridView ID="AIGrid" runat="server"
                                                      AutoGenerateColumns="False" PageSize="25"
                       AllowPaging="true" OnPageIndexChanging="OnAIGrid_PageIndexChanging" ShowFooter="true"  OnRowCreated ="AIGrid_RowCreated"
                   Font-Size="10pt" CssClass="grid" OnRowDataBound="AIGrid_RowDataBound">
                   <Columns>

                   </Columns>
                   </asp:GridView>

this is my aspx page and my cs page code is in below

if (e.Row.RowType == DataControlRowType.Footer)
        {
            GridViewRow Footerrow = new GridViewRow(1, 0, DataControlRowType.Footer, DataControlRowState.Insert);
            Label  txtCountry = new Label();
        }