Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Checking DatagridViewvalues in vb.net

  • 22-12-2008 05:51PM
    #1
    mountainyman
    Closed Accounts Posts: 2,268 ✭✭✭


    I am programming in vb.net

    I want to get a value from a datagridview by checking if the value of a column is null and if it is null moving up one cell checking if that's null and so on.
    
If Not (dgvTestDataGrid.Item("myColumn", thisrow).Value) Is DBNull.Value Then

gColValue= (dgvTestDataGrid.Item("myColumn", thisrow).Value)

End If

    So that if the value in mycolumn is null I look up one cell , if that's null 2 cells etc.

    MM


Comments

  • #2
    John_Mc
    Registered Users, Registered Users 2 Posts: 2,793 ✭✭✭John_Mc


    mountainyman wrote: »
    I am programming in vb.net

    I want to get a value from a datagridview by checking if the value of a column is null and if it is null moving up one cell checking if that's null and so on.
    
If Not (dgvTestDataGrid.Item("myColumn", thisrow).Value) Is DBNull.Value Then

gColValue= (dgvTestDataGrid.Item("myColumn", thisrow).Value)

End If

    So that if the value in mycolumn is null I look up one cell , if that's null 2 cells etc.

    MM

    Add an Else condition to obtain the column index using the column name. Subtract one and then access the Column value using the index instead of the column name.


Advertisement