After selecting an item in DropDownList in Dynamic GridView

soham jain

8y1.5k.NET

I used DropdownList in my Dynamic Gridview.

I want to auto fill Rate cell of Selected DropdownList Selected Item(Product name)

As shown in ScreenSort , as i selected Eraser in Productname column , the rate of Eraser gets auto fill on selecting the item in DropDownList using database table

Please Help

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suraj Kumar8y ago
Accepted answer
To add and do calculation on change of quantity you can modify your source code and code behind as shown below.

Add a new column as below.
<asp:TemplateField HeaderText="Qty">
                    <ItemTemplate>
                       <asp:TextBox ID="txtQty"  runat="server" AutoPostBack="true" OnTextChanged="txtNoOfStudents_TextChanged">asp:TextBox>
                    ItemTemplate>
                asp:TemplateField>
                <asp:TemplateField HeaderText="Total Amount">
               <ItemTemplate>
               <asp:Label ID="lblAmount" runat="server" Text="Total Amount">asp:Label>
               ItemTemplate>
asp:TemplateField>
Modify your code behind as below.
protected void ddlcouse_selectionchanged(object sender, EventArgs e)
        {
            string fee = "";
            DropDownList ddlcouse = (DropDownList)sender;
            GridViewRow Grow = (GridViewRow)ddlcouse.NamingContainer;
            cmdStudent = new SqlCommand("Select Fee from Student_Fee where Course='" + ddlcouse.SelectedItem.Text + "'", con);
            con.Open();
            fee = cmdStudent.ExecuteScalar().ToString();
            con.Close();
            ((Label)Grow.FindControl("lblfee")).Text = fee;

            TextBox txtQty = (TextBox)sender;
            ((Label)Grow.FindControl("lblAmount")).Text = Convert.ToString(Convert.ToInt32(fee) * Convert.ToInt32(txtQty.Text));
        }

        protected void txtQty_TextChanged(object sender, EventArgs e)
        {
            TextBox txtQty = (TextBox)sender;
            GridViewRow Grow = (GridViewRow)txtQty.NamingContainer;

            int fee = Convert.ToInt32(((Label)Grow.FindControl("lblfee")).Text);
            ((Label)Grow.FindControl("lblAmount")).Text = Convert.ToString(fee * Convert.ToInt32(txtQty.Text));
        }
Hope this will help you.
+1
soham jain8y ago
again thank you sir...
i did that ..and it helps

due to ur help i can proceed futhur to make sum of all the amount in the footer of the gridview

thank you sir
+1
soham jain8y ago
First of all thank you sir for ur time...
and yes ....it helps me...
thank you sir...

and sir i have another question

as i got the rate of the product ..now i have to make calculation using that value

so i want to access the texbox value...

can u pls help with it tooo??
+1
Suraj Kumar8y ago
You can try this with some minor modification and it is similar to your requirement
Source Code

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>DroupDownList SelectedIndexChanged Event Inside Gridviewtitle> title>
head>
<body>
    <form id="form1" runat="server">
    <div>
    <p>Student Couse and Fee Detailsb>p>
        <asp:GridView ID="GridView1"
            AutoGenerateColumns="false" runat="server"
            onrowdatabound="GridView1_RowDataBound">
            <Columns>
                <asp:BoundField DataField="Id" HeaderText="Student ID" />
                <asp:BoundField DataField="Name" HeaderText="Student Name" />
                <asp:TemplateField HeaderText="Course">
                    <ItemTemplate>
                        <asp:DropDownList ID="ddlCourse" AutoPostBack="true" OnSelectedIndexChanged="ddlcouse_selectionchanged" runat="server">
                        asp:DropDownList>
                    ItemTemplate>
                asp:TemplateField>
               <asp:TemplateField HeaderText="Fee For Course">
               <ItemTemplate>
               <asp:Label ID="lblfee" runat="server" Text="Select Couse To Display Fee..">asp:Label>
               ItemTemplate>
               asp:TemplateField>
            Columns>
        asp:GridView>
    div>
    form>
body>
html>
C# Code
SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString);
    SqlDataAdapter dastudent;
    DataSet ds_student, ds_course;
    SqlCommand cmdStudent;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
            bindStudentData();

    }
    private void bindStudentData()
    {
        dastudent = new SqlDataAdapter("Select * from Student_Fee", con);
        ds_student = new DataSet();
        dastudent.Fill(ds_student, "Student");
        GridView1.DataSource = ds_student.Tables[0];
        GridView1.DataBind();
    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        //Here We Identify The Row Type Of GridView
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            DropDownList ddlcourse = (DropDownList)e.Row.FindControl("ddlCourse");
            ds_course = new DataSet();
            dastudent = new SqlDataAdapter("Select Distinct Course from Student_Fee", con);
            dastudent.Fill(ds_course, "Course");
            ddlcourse.DataSource = ds_course.Tables[0];
            ddlcourse.DataTextField = "Course";
            ddlcourse.DataValueField = "Course";
            ddlcourse.DataBind();
        }
    }
And below is the dropdownselectedindex changed event to get the fee in your case rate.
protected void ddlcouse_selectionchanged(object sender, EventArgs e)
    {
        string fee="";
        DropDownList ddlcouse = (DropDownList)sender;
        GridViewRow Grow = (GridViewRow)ddlcouse.NamingContainer;
        cmdStudent=new SqlCommand ("Select Fee from Student_Fee where Course='"+ddlcouse.SelectedItem.Text+"'",con);
        con.Open();
        fee=cmdStudent.ExecuteScalar().ToString();
        con.Close();
        ((Label)Grow.FindControl("lblfee")).Text = fee;

    }
Hope this will help you.
+1