VB.NET

VB.NET RSS

looping thru database results

Please support our VB.NET advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Aug 2006

Posts: 32

Reputation: StatiX is an unknown quantity at this point

Solved Threads: 2

StatiX

Offline

Light Poster

looping thru database results

Oct 14th, 2007

Im trying to create a datagrid that will display an image instead of what is actually stored in the database. For instance if the result of a zodiac is leo, then show the leo image, or if it is cancer, show the cancer symbol, etc.. I am using a datagrid to show the results of the query but want to populate it with images instead of strings which is how they are stored in the database. Any ideas would be greatly appreciated or point me to a good tute on the subject. thanks

Always do what you wish you could..

•

Join Date: Mar 2006

Posts: 121

Reputation: manal is an unknown quantity at this point

Solved Threads: 17

manal

Offline

Junior Poster

Re: looping thru database results

Oct 16th, 2007

are you asking about how to loop thru database ? i think like this

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
count = Me.DataSet.Table_Name.Count
        For i = 0 To count - 1
            m = Me.DataSet. Table_Name.Rows(i).Item("Column_name")
            Select Case m
                Case "Leo"
                  Display image of Leo in   Me.DataGrid1.Item(i, 0)
                  .
                  .
                  .
                                      etc 
 
            End Select
count = Me.DataSet.Table_Name.Count
        For i = 0 To count - 1
            m = Me.DataSet. Table_Name.Rows(i).Item("Column_name")
            Select Case m
                Case "Leo"
                  Display image of Leo in   Me.DataGrid1.Item(i, 0)
                  .
                  .
                  .
                                      etc 

            End Select