How to select between two columns amount values?

Question

How to select between two columns amount values? using dropdown control. Columns name is: from amount and end amount.

Satyapriya Nayak · Answer

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

magesh manavalan · Answer

Pls send me table Design in that coding.

How to select between two columns amount values?

Answers (2)