Need use LIKE %

Rijwan Ansari5y ago

Accepted answer

Hi,

var KooperacijaRN = this.radni_nalozi_2018DataGridView.Rows.Cast().Where(row => row.Cells["R.b. RN"].Value.ToString().Contains("OK"));

+2

Satya Karki5y ago

Hi, use Contains then it will work.

var KooperacijaRN = this.radni_nalozi_2018DataGridView.Rows.Cast().Where(row => row.Cells["R.b. RN"].Value.ToString().Contains("OK"));

+1

Sachin Singh5y ago

what you need is similar to Contains() method of Linq

like '%SearchString%' = Contains("SearchString")
like '%SearchString' = StartsWith("SearchString")
like 'SearchString%' = EndsWith("SearchString")

var KooperacijaRN = this.radni_nalozi_2018DataGridView.Rows.Cast().Where(row => row.Cells["R.b. RN"].Value.ToString().Contains("KO"));

+3

Salman Beg5y ago

You can't use the like but you can use contains which works perfectly fine. See this example, https://stackoverflow.com/questions/5417070/c-sharp-version-of-sql-like

+2