Solved

Bind DataGridView to ArrayList

Posted on 2008-10-17
9
4,554 Views
Last Modified: 2013-11-07
I am trying to do something simple here...

I have a class..

    Public Class queryAttribute
        Public ccDisplayName As String = ""
        Public ccQueryType As Integer
        Public ccQueryValue As String = ""
    End Class

Then there is an arraylist of this class

dim myList as ArrayList

I call myList.add for a number of items and I can verify they are there.

Then I try to set the datasource of the datagridview gvAttributes to be myList

so gvAttributes.Datasource = myList

When I initialize the app I do this..

With gvAttributes
                .AutoGenerateColumns = False
                .ColumnHeadersVisible = False
                .Columns.Add("Type", "Type")
                .Columns.Add("Value", "Value")
                Dim colBmp As New Bitmap(Application.StartupPath & "\resources\delete.gif")
                Dim colImg As Image
                colImg = colBmp

                Dim col As New DataGridViewImageColumn
                col.Image = colImg
                .Columns.Add(col)
            End With

Then when the content of the arraylist is changed I do this..

                With gvAttributes
                    '.AutoGenerateColumns = True
                    .ColumnHeadersVisible = True
                    .Columns(0).DataPropertyName = "ccDisplayName"
                    .Columns(1).DataPropertyName = "ccQueryValue"
                End With
                gvAttributes.DataSource = myList

Can someone please tell me why I dont have rows in my grid? I can see when I look at the properties of the grid in "watch" that the datasource has rows.. why are they not showing up here?

Please advise.
0
Comment
Question by:NTGuru705
  • 4
  • 4
9 Comments
 
LVL 1

Author Comment

by:NTGuru705
ID: 22745331
any thoughts to help a poor soul here?
0
 
LVL 13

Expert Comment

by:sm394
ID: 22745690
try
gvAttributes.Datasource = myList
gvAttributes.DataBind() ' if its missing
0
 
LVL 48

Expert Comment

by:jpaulino
ID: 22746454
sm394,
DataBind() method is only for ASP.NET gridviews not for DataGridView
 
NTGuru705,
You are trying to bind the datagridview with the collection but you cannot do that way. Create a new datatable (instead of the class) and add the new datarows. Then you can bind easily.
0
MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

 
LVL 1

Author Comment

by:NTGuru705
ID: 22746959
I am not sure I follow 100% could you elaborate on this please?
0
 
LVL 48

Accepted Solution

by:
jpaulino earned 500 total points
ID: 22747387
Small example
        Dim dt As New DataTable
        Dim rnd As New Random()
 
        dt.Columns.Add(New DataColumn("ID", GetType(Integer)))
        dt.Columns.Add(New DataColumn("Description", GetType(String)))
        dt.Columns.Add(New DataColumn("Value", GetType(Integer)))
 
        ' Here you add the values
        For x As Byte = 1 To 250
            Dim dr As DataRow = dt.NewRow()
            dr("ID") = x
            dr.Item("Description") = "Description " & x.ToString
            dr.Item("Value") = rnd.Next
            dt.Rows.Add(dr)
        Next
 
       ' Bind the information to the DataGridView1 
       ' (you don't need to create the columns before)
        Me.DataGridView1.DataSource = dt

Open in new window

0
 
LVL 1

Author Comment

by:NTGuru705
ID: 22750023
I suppose I am confused in why the arraylist doesnt work.. I understand your workaround.. (thank you for example) but I would like to understand why the arraylist binds but doesnt display... could you help me understand that one?

Thank you for your help.
0
 
LVL 48

Expert Comment

by:jpaulino
ID: 22750034
Because you're not binding a regular arraylist but a structure. Datagridview doesn't guess that!
0
 
LVL 1

Author Comment

by:NTGuru705
ID: 22753206
so in what cases would binding an arraylist work? It seems the most effective way to use an array list is an array of a class.  What is a case that would work?  I am using an arraylist because it is being maintained by the UI and things are added/removed from the list.  So I just use the .remove to take the item out...

I suppose I could do just the same with a datatable but I am trying to understand the why behind it.. could you give me a scenario (other than a simple arraylist of strings) that would work?  Are there any scenarios where binding to a datagridview with an arraylist would work?

Thanks
0
 
LVL 48

Expert Comment

by:jpaulino
ID: 22813226
so in what cases would binding an arraylist work?
 
If you use a regular arraylist, just with values and not structures, it will work.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_4334-Minify-and-Concatenate-Your-Scripts-and-Stylesheets.html)…
Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question