i want to show the selected values of two checkbox(checkboxlist) in grid view ?

See more:

SQL-Server-2005

SQL-Server

, +

In my code if i select any one check box means it shows correct value in grid view.
but if i select both means it shows additonal values except i bound the values
in grid view based on search results in previous page.,

String sqlText = Session["grid"].ToString(); // here the bounded value


//session[grid] contains following query..

(Select airlineimg,stops,departure_time,arrival_time,duration,price from DomesticAirlines where departure='" + txt_dep_date.Text.Trim() + "' AND origin='" + txt_origin.Text.Trim() + "' AND destination='" + txt_dest.Text.Trim() + "'")
        String sqlFilterText = "";
        int index = 0;
        
        foreach (ListItem item in chbklist1.Items)
        {
            index += 1;
            if (item.Selected)
            {
                String paramName = "@airlines_id" + index.ToString().Trim();
                //String paramName = "@airlines_id";
                SqlParameter param = new SqlParameter(paramName, SqlDbType.Int);
                param.Value = item.Value.Trim();
                cmd.Parameters.Add(param);
                     
                    sqlFilterText += " airlines_id = " + paramName + " or ";
                

                
            }
        }

        if (!String.IsNullOrEmpty(sqlFilterText))
        {
            
                sqlText += " AND " + sqlFilterText.Substring(0, sqlFilterText.Length - 3);
        }
        cmd.CommandText = sqlText;
        cmd.Connection = cnn;

        SqlDataAdapter adapter = new SqlDataAdapter(cmd);
        DataTable tbl = new DataTable();
        adapter.Fill(tbl);
        GridView1.DataSource = tbl;
        GridView1.DataBind();