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

Krishna

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();

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Krishna11y ago
by doing so unable to view the table
0
Manish Kumar Choudhary11y ago
in your code you mention "%" at the last of your string add it before and try
0
Krishna11y ago
in the above code i already mentioned the command
0
Manish Kumar Choudhary11y ago
try this.
any keyword not start with x
string x = "%"+Request.QueryString["Name"];
0
Krishna11y ago
by writing this command its displaying the whole table not the specific one
0
Manish Kumar Choudhary11y ago
use this
scom.CommandText = select * from proper where keyword NOT Like @x
0