Combo box to grid view

Vijay Yadav15y ago

Resolved?

0

Manoj Tandon15y ago

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)

{

SqlDataAdapter da;

DataSet ds = new DataSet();

try

{

da = new SqlDataAdapter("select book_Id, book_name from book where category_name = '" + DropDownList1.SelectedItem.Text + "'", "your connection string");

da.Fill(ds);

GridView1.DataSource = ds.Tables[0];

GridView1.DataBind();

}

catch (Exception)

{

throw;

}

0

Jiteendra Sampathirao15y ago

Hi,
set the autopostback=true propertyto the combo box...

In the combo box event...

store the combo box selected value in a variable....

write the select query like...

select a,b,c,d from dat_table where some-thing=a;

write some method to store the retrieved values in a DataSet.....and then to GridView

Refer this link for More understanding(code available)

Link

Hope it help....

0