searching a text in a Datatable September 13, 2013 DataRow[] filesWithAA = dt.Select("Column_name LIKE '%KS%'"); dt.DefaultView.RowFilter = "[Column_name] LIKE '%(KS)%'"; DataTable dtOutput = dt.DefaultView.ToTable(); Mehr anzeigen
Select the rows depending upon the occurence September 13, 2013 SELECT `id` FROM table GROUP BY id HAVING COUNT(*) = 1 id column1 column2 -------------------------- 1 value1 value2 1 value1 value2 2 value1 value2 Executing the above query will get a result id --- 2 while occurence of the id = 2 is only once Mehr anzeigen