• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 268
  • Last Modified:

VB.net Hide checkbox once product has been sold

I need to figure out how to Hide a product (Exclusive Back Cover) once it has been sold. I know that I will need to query the database and see if BackCover = 1 and if so no longer show the checkbox ckBackCover.

I am not sure how to query the database and search through all records
0
Albee_J
Asked:
Albee_J
1 Solution
 
mpeaden2Commented:

please mark as answer if this helps...
'Read all Potting Types and select only distinct
        cmdSql = New SqlCommand("SELECT statement here", sqlCon)
        Dim DA As New SqlDataAdapter(cmdSql)
        Dim DT As New DataTable
        Dim DR As DataRow
        Dim Counter As String = Nothing
        'Fill dataset
        DA.Fill(DT)
        
        For Each DR In DT.Rows
            'Place your show/hide code here
        Next
        'Finshed with Adapter/Datatable
        DA.Dispose()
        DT.Dispose()

Open in new window

0
 
Albee_JAuthor Commented:
Thank you!  I will implement and advise.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now