There must be something I am missing, since I have no idea how the code that was posted is relevant.

Hi Magesh, Untitled Page onselectedindexchanged="DropDownList2_SelectedIndexChanged"> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Paging_in_GridView { public partial class WebForm3 : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlCommand com; string str; protected void Page_Load(object sender, EventArgs e) { DropDownList1.AutoPostBack = true; DropDownList2.AutoPostBack = true; SqlConnection con = new SqlConnection(connStr); if (!IsPostBack) { DropDownList1.Items.Add("Choose fromamount"); con.Open(); str = "select * from Mobile"; com = new SqlCommand(str, con); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { DropDownList1.Items.Add(reader["fromamount"].ToString()); } reader.Close(); con.Close(); DropDownList2.Items.Add("Choose endamount"); con.Open(); str = "select * from Mobile"; com = new SqlCommand(str, con); SqlDataReader reader1 = com.ExecuteReader(); while (reader1.Read()) { DropDownList2.Items.Add(reader1["endamount"].ToString()); } reader1.Close(); con.Close(); } } protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e) { SqlConnection con = new SqlConnection(connStr); try { con.Open(); str = "select model from Mobile where fromamount between '" + DropDownList1.SelectedItem.Text + "' and '" + DropDownList2.SelectedItem.Text + "' "; com = new SqlCommand(str, con); GridView1.DataSource = com.ExecuteReader(); GridView1.DataBind(); } catch (Exception ex) { Response.Write(ex.Message); } con.Close(); } } } Thanks If this post helps you mark it as answer

Answers

My Doubt?

magesh manavalan

13y

1.4k

How to do that?

Answers (3)

Forum Statistics

Please welcome our newest member Rati Vijay Khabade.
3,095,988 users have contributed to 147,391 threads and 483,652
In the past 24 hours, we have 1 new threads, 6 new posts, and 100 new users.
In last week, the most popular thread is 'OOPS Concept'.

Upcoming Events

View all

The Cloud Show with Magnus Mårtensson ft. Mads Kempel Sørensen - Ep: 75
AI Agents Conference - 2025