Looking for word in table row

Looking for word in table row

Page 1 of 1

1 Replies - 379 Views - Last Post: 21 December 2010 - 06:33 AM Rate Topic: -----

#1 lyalyapo  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 21-December 10

Looking for word in table row

Posted 21 December 2010 - 05:55 AM

Hi

I am new with Visual C# and encountered this problem :

I have to tables, let's say table1 and table2. In table1 exist column "sentense", and there is "word" column in table2. I have to check is this word occurs in sentence or not.

I know that writing in sql this will be staightforward : "SELECT * FROM table1 WHERE table1.sentence LIKE %table2.word%"

I know it should be quite easy, but I am really struggling to write the code for it :(.

Thank you

Is This A Good Question/Topic? 0
  • +

Replies To: Looking for word in table row

#2 mavarazo  Icon User is offline

  • D.I.C Head
  • member icon

Reputation: 35
  • View blog
  • Posts: 171
  • Joined: 25-October 10

Re: Looking for word in table row

Posted 21 December 2010 - 06:33 AM

You table2.word has to be a parameter :). Google will explain it, when you need more infos.
Was This Post Helpful? 0
  • +
  • -
Page 1 of 1