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

12y

1.1k

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?