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.

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

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.