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

1 Active Directory

How to do that?

Answers (3)

Forum Statistics

Please welcome our newest member Zadux Infotech.
2,381,688 users have contributed to 122,515 threads and 389,032
In the past 24 hours, we have 0 new threads, 0 new posts, and 0 new users.
In last week, the most popular thread is 'Testing Forum WYSIWYG Editor Formatting'.

Upcoming Events

View all

🎉 .NET Conf – Patna

Our Training Programs

View all

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

My Doubt?

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)