dropdown list related

Question

i have a dropdown list which has 3 options select, active, completed   when page loads it wont show gridview when we select option then only gridview is generated based on the option   but i want aactive gridview to be generated when the pageloads then user can select particular option    whn page loads i want active gridview to be generated on page load

Amit Kumar · Answer

Thanks for paste your code. You can do one thing. Create a method for only bind select query option. And call it on page load and then your problem will solve.

Amit Kumar · Answer

Hi,     Can you show me your binding code ?

Rupesh Kahane · Answer

After your page load write one ajax call which will take value from current drop down & passes to action method, now from action method returns data into Json, JsonResult, List format & bind to your grid / div.

Refer my article which has a button click event & on button click event I had ajax call & taking data from action result & binding it. Just for your reference

1) https://www.c-sharpcorner.com/article/different-json-result-types-used-in-mvc/

2) https://www.c-sharpcorner.com/article/dynamically-bind-the-dropdownlist-on-change-event-in-asp-net-mvc-5/

Let me know if any concern.

Subin Thomas · Answer

hey amit below is my binding code   gridview code :   "GridView1"  runat= "server"  BackColor= "White"             BorderColor= "#999999"  BorderStyle= "Solid"  BorderWidth= "1px"  CellPadding= "3"             ForeColor= "Black"  GridLines= "Vertical"  Height= "172px"  Width= "879px"                 AllowPaging= "True"  onpageindexchanging= "OnPageIndexChanging" >            "#CCCCCC"  />                            "Sr. No" >                                                                                            "#CCCCCC"  />            "Black"  Font-Bold= "True"  ForeColor= "White"  />            "#999999"  ForeColor= "Black"  HorizontalAlign= "Center"  />            "#000099"  Font-Bold= "True"  ForeColor= "White"  />            "#F1F1F1"  />            "#808080"  />            "#CAC9C9"  />            "#383838"  />
binding code protected   void  DropDownGrid()           {               string orgname = OrgNM;               SqlConnection con =  new  SqlConnection(kkd);                   if  (DropDownList1.SelectedItem.Text ==  "select" )               {                      con.Open();                      SqlCommand cmd =  new  SqlCommand( "select query' " , con);                      cmd.Parameters.AddWithValue( "@orgname" , orgname);                   SqlDataAdapter da =  new  SqlDataAdapter(cmd);                      DataSet ds =  new  DataSet();                   da.Fill(ds);                   GridView1.DataSource = ds;                   GridView1.DataBind();                   con.Close();                              }                else   if  (DropDownList1.SelectedItem.Text ==  "Active Projects" )               {                   con.Open();                      SqlCommand cmd =  new  SqlCommand("select query, con);                      cmd.Parameters.AddWithValue( "@orgname" , orgname);                   SqlDataAdapter da =  new  SqlDataAdapter(cmd);                      DataSet ds =  new  DataSet();                   da.Fill(ds);                   GridView1.DataSource = ds;                   GridView1.DataBind();                   con.Close();                  }                else   if  (DropDownList1.SelectedItem.Text ==  "Past Projects" )               {                   con.Open();                      SqlCommand cmd =  new  SqlCommand( "select query" , con);                      cmd.Parameters.AddWithValue( "@orgname" , orgname);                   SqlDataAdapter da =  new  SqlDataAdapter(cmd);                      DataSet ds =  new  DataSet();                   da.Fill(ds);                   GridView1.DataSource = ds;                   GridView1.DataBind();                   con.Close();                  }              }
i have 3 options in gridview   1st=> select 2nd=> active projects 3rd=> past projects    when page load i wanted to fire selet option query

Subin Thomas · Answer

hey rupesh mine is not an mvc architicture