title: Filter records from the dataset in vb.net
body: <p>I want to <strong>filter values from a dataset</strong>. It contain phone numbers <em>starting with zero and non zero values</em>. How can I filter a phone number (start with non zero no) from the dataset. Below is the vb.net code and the resulting error.</p>
  
  <pre><code>cmd = New OracleCommand("select  PHONE from  reports.renewal_contact_t where run_date=to_date('" + TextBox1.Text + "','mm/dd/yyyy') and  EXP_DATE =to_date('" + TextBox2.Text + "','mm/dd/yyyy') and  region not in('TNP')", cn)
  ada = New OracleDataAdapter(cmd)
  ada.Fill(ds, "reports.renewal_contact_t ")
  Dim ds1 As New DataSet
  ds1.Tables("reports.renewal_contact_t").DefaultView.RowFilter = "PHONE NOT like'0'"
  </code></pre>
  
  <p><strong>Error:</strong> Object reference not set to an instance of an object. error in rowfilter line</p>