title: Datatable.Select with Like in VB.net
body: <p>I have a datatable where i am trying to do 
  datatable.Select(Name Like '#%#') but getting error that invalid pattern(expecting result of a table with name col having #Mike#,#Brow#..).  Using escape sequense dint for all items dint work fine too. Many suggest to use Linq - but am new to it. How can i do this filter with Linq from this datatable. </p>
  
  <p>This is a sample of what i was trying to do..</p>
  
  <pre><code> Dim dtSamp As Data.DataTable
      dtSamp = New Data.DataTable
      dtSamp.Columns.Add("Name")
      dtSamp.Columns.Add("Marks")
  
      Dim dr As DataRow
      dr = dtSamp.NewRow()
      dr.Item(0) = "AAA"
      dr.Item(1) = "50"
      dtSamp.Rows.Add(dr)
      dr = dtSamp.NewRow()
      dr.Item(0) = "#bbb#"
      dr.Item(1) = "60"
      dtSamp.Rows.Add(dr)
      dr = dtSamp.NewRow()
      dr.Item(0) = "ccc"
      dr.Item(1) = "44"
      dtSamp.Rows.Add(dr)
  
      Dim drResult As DataRow()
      drResult = dtSamp.Select("Name Like '#%#'")
  
      Dim dtOutPutTable As Data.DataTable
      dtOutPutTable = drResult.CopyToDataTable()
  </code></pre>
  
  <p>In the dtOutPutTable i was expecting 1 row ie, #bbb# in it.. but the Select function fails.</p>