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.3k

How to do that?

Answers (3)

Next Recommended Forum

How to select between two columns amount values?

How to do Date Expired in my Application?

Forum Statistics

Please welcome our newest member Desert Safari Dubai.
3,083,497 users have contributed to 147,418 threads and 483,473
In the past 24 hours, we have 6 new threads, 14 new posts, and 101 new users.
In last week, the most popular thread is 'System.Data.SqlClient'.

Upcoming Events

View all

The Cloud Show with Magnus Mårtensson ft. Marc Duiker - Ep: 69
Cloud Security & DevSecOps: Why Your Code is Never Really Safe - Code Red: Ep.7
Excel Automation with Power Automate : Automate Your Business Processes - Ep.3