jumping from nullvalue fields in the dataset

• • Reply

  15 years ago

  by ravikanthT

  ravikanth

  , India

  Joined 15 years ago

  hello,

  i am doing a web app with avb.net  and sqlserver.

  i have retrived a table in to the dataset,in that one column1 has some null values ,

  my requirement is to retrive the data from the row where the column1 has no null values and display in the textbox fields(this application is for getting the previous reciepts i.e bills)

  plzz give me code example for this

  thanQ

  Report abuse
• • Reply

  15 years ago

  by jmcilhinney

  John McIlhinney

  Sydney, Australia

  Joined 15 years ago
  Set the DefaultView.RowFilter property to "ColumnName IS NOT Null" and then you can get the filtered data from the DefaultView property instead of the Rows property.
  
  
  Report abuse