Filtering rows from diffrent dataset or DataTable !!

Ash,


If I understand your question, simply do the same database query with "NOT" prepended.


Joe

 

Please I need help with ADO.NET + SQL ....I want to retreive remaining rows from a select statement ( The rows that are not came under the where condition...
i.e : Imagin that we have a page called search.aspx that contains a textbox search and a button ...
after the user entered the desired word to search ... the matched data will be displayed in a datagrid and other data 'semi-matched data' will be displayed in other data grid under a caption : "Did you mean ?" ... I used 'like % + str +% SQL query ....in the second datagrid ,so how can I do that ?

 

Are you looking for something like:

ds.Tables[table_name].Select('field_name = 'some_field_value'')[0]
..or..
ds.Tables[table_name].Select('field_name like '%me_field_value'')[0]

..ad ADO.NET doesn't like <> in filter expressions. At least not on Mono, I can't remember testing it on .NET for sure.

HTH,
Dilton

 

Thanx Dilton for ur reply ... I'll try it now ... Thanx dear