Pass Parameter in C# DropDownList using Entity Framework

Method:

protected void LoadDropDownList(DropDownList ddl, object ds, string vf, string tf)

        {           

            ddl.DataSource = ds;

            ddl.DataValueField = vf;

            ddl.DataTextField = tf;

            ddl.DataBind();

            ddl.Items.Insert(0, new ListItem("--Select--", "0"));

        }

  

How to call this method:

LoadDropDownList(ddlRegion, r.GetAll(), "RegionID", "RegionName");

Add GridView Column Total in ASP.NET C#

Grid View Style(Make ShowFooter = true & Add Footer Template)

<asp:GridView ID="gvCommissionDetails" runat="server" ShowFooter="true" CssClass="gridview"

        AutoGenerateColumns="False"

        onrowdatabound="gvCommissionDetails_RowDataBound">

    <AlternatingRowStyle CssClass="gridview_alter"/>

        <Columns>

            <asp:TemplateField HeaderText="CommissionDate">

                <EditItemTemplate>

                    <asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("CommissionDate") %>'></asp:TextBox>

                </EditItemTemplate>

                <ItemTemplate>

                    <asp:Label ID="Label1" runat="server"

                        Text='<%# Bind("CommissionDate", "{0:dd-MMM-yyyy}") %>'></asp:Label>

                </ItemTemplate>

            </asp:TemplateField>

            <asp:TemplateField HeaderText="ClientCode">

                <EditItemTemplate>

                    <asp:TextBox ID="TextBox5" runat="server" Text='<%# Bind("ClientCode") %>'></asp:TextBox>

                </EditItemTemplate>

                <ItemTemplate>

                    <asp:Label ID="Label2" runat="server" Text='<%# Bind("ClientCode") %>'></asp:Label>

                </ItemTemplate>

            </asp:TemplateField>

            <asp:TemplateField HeaderText="FA">

                <EditItemTemplate>

                    <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("FA") %>'></asp:TextBox>

                </EditItemTemplate>

                <ItemTemplate>

                    <asp:Label ID="lblFA" runat="server" Text='<%# Bind("FA") %>'></asp:Label>

                </ItemTemplate>

                <FooterTemplate>

                    <asp:Label ID="lblFATotal" runat="server"></asp:Label>

                </FooterTemplate>

            </asp:TemplateField>

            <asp:TemplateField HeaderText="UM">

                <EditItemTemplate>

                    <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("UM") %>'></asp:TextBox>

                </EditItemTemplate>

                <ItemTemplate>

                    <asp:Label ID="lblUM" runat="server" Text='<%# Bind("UM") %>'></asp:Label>

                </ItemTemplate>

                <FooterTemplate>

                    <asp:Label ID="lblUMTotal" runat="server"></asp:Label>

                </FooterTemplate>

            </asp:TemplateField>

            <asp:TemplateField HeaderText="CO">

                <EditItemTemplate>

                    <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("CO") %>'></asp:TextBox>

                </EditItemTemplate>

                <ItemTemplate>

                    <asp:Label ID="lblCO" runat="server" Text='<%# Bind("CO") %>'></asp:Label>

                </ItemTemplate>

                <FooterTemplate>

                    <asp:Label ID="lblCOTotal" runat="server"></asp:Label>

                </FooterTemplate>

            </asp:TemplateField>

           

        </Columns>

    </asp:GridView>

Code in .cs page

decimal totalFA = 0M;

        decimal totalUM = 0M;

        decimal totalCO = 0M;

        protected void gvCommissionDetails_RowDataBound(object sender, GridViewRowEventArgs e)

        {

            if (e.Row.RowType == DataControlRowType.DataRow)

            {               

                decimal FACommission = Convert.ToDecimal(((Label)e.Row.FindControl("lblFA")).Text);

                totalFA += FACommission;

                decimal UMCommission = Convert.ToDecimal(((Label)e.Row.FindControl("lblUM")).Text);

                totalUM += UMCommission;

                decimal COCommission = Convert.ToDecimal(((Label)e.Row.FindControl("lblCO")).Text);

                totalCO += COCommission;

            }

            if (e.Row.RowType == DataControlRowType.Footer)

            {

                Label TotalFACommission = (Label)e.Row.FindControl("lblFATotal");

                TotalFACommission.Text = totalFA.ToString();

                Label TotalUMCommission = (Label)e.Row.FindControl("lblUMTotal");

                TotalUMCommission.Text = totalUM.ToString();

                Label TotalCOCommission = (Label)e.Row.FindControl("lblCOTotal");

                TotalCOCommission.Text = totalCO.ToString();

            }

        }