Webservice for filtering data in gridview on dropdown list item select

Question

hai all,

i have a page in which i have a grid view and i have a dropdownlist for filtering, when we select a item from drop down list the data should be filtered and it should be binded to the grid view and display according to the item selected in the drop down list. how can we do this using webservices can anybody help it is urgent.

thanks.

Satyapriya Nayak · Answer

Hi Johny, Try this... Untitled Page onselectedindexchanged="DropDownList1_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 Select_dropdownlist_value_gridview { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string str; SqlCommand com; DataSet ds; SqlDataAdapter sqlda; protected void Page_Load(object sender, EventArgs e) { DropDownList1.AutoPostBack = true; SqlConnection con = new SqlConnection(strConnString); if (!IsPostBack) { DropDownList1.Items.Add("Choose id"); con.Open(); str = "select * from test"; com = new SqlCommand(str, con); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { DropDownList1.Items.Add(reader["id"].ToString()); } reader.Close(); con.Close(); } } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = "select * from test where id='" + DropDownList1.SelectedItem.Text + "'"; com = new SqlCommand(str, con); sqlda = new SqlDataAdapter(com); ds = new DataSet(); sqlda.Fill(ds, "test"); GridView1.DataMember = "test"; GridView1.DataSource = ds; GridView1.DataBind(); con.Close(); } } } Thanks

Webservice for filtering data in gridview on dropdown list item select

Answers (1)