private void BindGrid() { DataTable dt = new DataTable(); string query = " select * from gvdetails17 WHERE 1=1 "; SqlCommand cmd = new SqlCommand(); cmd.Connection = cn; if (ddlAddSalary1.SelectedValue != "") { gvDetails.Visible = false; string[] sal = ddlAddSalary1.SelectedValue.Split('-'); string from = sal[0]; string to = sal[1]; query += " and Sal between @fromsal and @tosal "; cmd.Parameters.AddWithValue("@fromsal", from); cmd.Parameters.AddWithValue("@tosal", to); } if (ddlAge.SelectedValue != "") { gvDetails.Visible = false; string[] age = ddlAge.SelectedValue.Split('-'); string from1 = age[0]; string to1 = age[1]; query += " and Age between @fromage and @toage "; cmd.Parameters.AddWithValue("@fromage", from1); cmd.Parameters.AddWithValue("@toage", to1); gvDetails.Visible = true; } cmd.CommandText = query; cmd.CommandType = CommandType.Text; SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); gvDetails.DataSource = dt; gvDetails.DataBind(); } protected void ddlAddSalary1_SelectedIndexChanged1(object sender, EventArgs e) { BindGrid(); } protected void ddlAge_SelectedIndexChanged(object sender, EventArgs e) { BindGrid(); }
select * from gvdetails17 WHERE 1=1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)