?
Solved

Datagridview combobox column problem

Posted on 2009-04-10
1
Medium Priority
?
212 Views
Last Modified: 2012-05-06
I have a grid that has a column of comboboxes.  I'm pulling from a database for three separate conditions and filling three datasets.  I want to bind these datasets to one particular column, but only every third cell.  In other words, row one should bind to ds1, row 2 to ds2, row 3 to ds3, row 4 to ds1, row 5 to ds2, etc.

I am doing this

        For rw As Integer = 0 To 23 Step 3
            Dim cell As New DataGridViewComboBoxCell
            cell.DataSource = dsslide1
            dgvNewJob.Rows(rw).Cells(1) = cell
         Next

        For rw As Integer = 1 To 23 Step 3
            Dim cell As New DataGridViewComboBoxCell
            cell.DataSource = dsslide1
            dgvNewJob.Rows(rw).Cells(1) = cell
         Next

I get errors and the box does not contain any data.

Any ideas what I am doing wrong?
0
Comment
Question by:ddepuemd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 

Accepted Solution

by:
ddepuemd earned 0 total points
ID: 24121865
I found the answer to load different values in comboboxes in the same column of a datagridview.
            'fill slide and type 1
            For rw As Integer = 0 To 23 Step 3
                Try
                    Dim cell As New DataGridViewComboBoxCell
                    For cnt As Integer = 0 To dsslide1.Tables(0).Rows.Count - 1
                        cell.Items.Add(dsslide1.Tables(0).Rows(cnt).Item("description"))
                    Next
                    JobGrid.Rows(rw).Cells(1) = cell
 
                    Dim cell1 As New DataGridViewComboBoxCell
                    For cnt As Integer = 0 To dstype1.Tables(0).Rows.Count - 1
                        cell1.Items.Add(dstype1.Tables(0).Rows(cnt).Item("description"))
                    Next
                    JobGrid.Rows(rw).Cells(7) = cell1
                Catch ex As Exception
                    errlog.WriteError("Error in filling slide1 and type1: " & ex.Message, "LoadNewJob")
                End Try
            Next
 
            'fill slide and type 2
            For rw As Integer = 1 To 23 Step 3
                Try
                    Dim cell As New DataGridViewComboBoxCell
                    For cnt As Integer = 0 To dsslide2.Tables(0).Rows.Count - 1
                        cell.Items.Add(dsslide2.Tables(0).Rows(cnt).Item("description"))
                    Next
                    JobGrid.Rows(rw).Cells(1) = cell
 
                    Dim cell1 As New DataGridViewComboBoxCell
                    For cnt As Integer = 0 To dstype2.Tables(0).Rows.Count - 1
                        cell1.Items.Add(dstype2.Tables(0).Rows(cnt).Item("description"))
                    Next
                    JobGrid.Rows(rw).Cells(7) = cell1
                Catch ex As Exception
                    errlog.WriteError("Error in filling slide2 and type2: " & ex.Message, "LoadNewJob")
                End Try
            Next
 
            'fill slide and type 3
            For rw As Integer = 2 To 23 Step 3
                Try
                    Dim cell As New DataGridViewComboBoxCell
                    For cnt As Integer = 0 To dsslide3.Tables(0).Rows.Count - 1
                        cell.Items.Add(dsslide3.Tables(0).Rows(cnt).Item("description"))
                    Next
                    JobGrid.Rows(rw).Cells(1) = cell
 
                    Dim cell1 As New DataGridViewComboBoxCell
                    For cnt As Integer = 0 To dstype3.Tables(0).Rows.Count - 1
                        cell1.Items.Add(dstype3.Tables(0).Rows(cnt).Item("description"))
                    Next
                    JobGrid.Rows(rw).Cells(7) = cell1
                Catch ex As Exception
                    errlog.WriteError("Error in filling slide3 and type3: " & ex.Message, "LoadNewJob")
                End Try
            Next

Open in new window

0

Featured Post

Technology Partners: 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!

Question has a verified solution.

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

This article explains how to create and use a custom WaterMark textbox class.  The custom WaterMark textbox class allows you to set the WaterMark Background Color and WaterMark text at design time.   IMAGE OF WATERMARKS STEPS Create VB …
Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

765 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