6
Answers

i will like to retrieve the element which is not like same

Krishna

Krishna

9y
915
1
 i would like to retrieve the the text which is not like the text i entered in the text box here is my code i am not getting the table displayed 


.cs

        string x = Request.QueryString["Name"] + "%";

        con.Open();
        SqlCommand scom = new SqlCommand();
        scom.Connection = con;

        scom.CommandText = "select Keyword from products where keyword NOT  LIKE @x ";
       // scom.CommandText = "select * from proper where @x notlike keyword";
        scom.Parameters.AddWithValue("@x", x);
        DataSet ds = new DataSet();
        SqlDataAdapter dap = new SqlDataAdapter();
        dap.SelectCommand = scom;
        dap.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataBind();
Answers (6)