user may pass one or multiple parameter from previous page...how can one query handle all?
string reg_no = Request.QueryString["reg_no "];
string name= Request.QueryString["name"];
string dept= Request.QueryString["dept"];
using (SqlConnection cnn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["constr"].ConnectionString))
{
cnn.Open();
string query = "";
query = "select * from tab_emp where emp_name like '%" + name+"%'" or regst_no=" + reg_no or dept_name like '%" + dept+"%'"
Go to the complete details ...