After selecting an item in DropDownList in Dynamic GridView

Question

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

Suraj Kumar · 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.

Suraj Kumar · Answer

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.

soham jain · Answer

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

soham jain · Answer

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??