jumping from nullvalue fields in the dataset

  • 11 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

  • 11 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.

Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Beware of bugs in the above code; I have only proved it correct, not tried it.” - Donald Knuth