Solved

Datagridview combobox column problem

Posted on 2009-04-10
1
205 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
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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

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 …
I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

760 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now