error occured datagridviewcomboboxcell value is not valid USING VB.NET

Question

0.00/5 (No votes)

See more:

VB

Dim cmb As New DataGridViewComboBoxCell
    cmb.DisplayMember = "Lastname"
       cmb.ValueMember = "VendorId"

    '''fill dataset using some query having 2 columns lastname and vendorId

    dim m_cnDB as new SqlConnection(connectionString)
    m_cnDB.Open()
    Dim da As New SqlDataAdapter(SQL, m_cnDB)
       Dim ds As New DataSet("Results")
       da.Fill(ds)
    m_cnDB.close()

    ''adding datasource to comboboxCell

    cmb.DataSource = Nothing
       cmb.DataSource = ds.Tables(0)

    ''insert row to datagrid view  3rd column is my combobox column

    DataGridView1.Rows.Insert(DataGridView1.NewRowIndex, New Object() {"1", "xyz", cmb})

I doesn't get error at compile time even while debugging .
but when gridview loads it get exception.

system argument exception: datagridviewcomboboxcell value is not valid

Please help to find out solution

Thank You

Posted 19-Jan-15 19:36pm

yogeshysankar

Add a Solution

Comments

Sinisa Hajnal 20-Jan-15 2:23am

It sounds more like data error (note that cell VALUE is not valid). I'd say your VendorId is invalid field name or some such minor oversight.

yogeshysankar 20-Jan-15 2:54am

Yes it is tell to handle data error event .
Actually i am trying to add datasource to DataGridViewComboBoxCell every time when new row inserted instead to add to DataGridViewComboBoxColumn ,

so is there any trouble of blank row that automatically inserted at the bottom of gridview?

yogeshysankar 20-Jan-15 2:53am

Yes it is tell to handle data error event .
Actually i am trying to add datasource to DataGridViewComboBoxCell every time when new row inserted instead to add to DataGridViewComboBoxColumn ,

so is there any trouble of blank row that automatically inserted at the bottom of gridview?

Sinisa Hajnal 20-Jan-15 4:45am

Don't go into the database for each row to fill it. In form load take the data you need and set datasource of the combobox column in RowDataBound Event with vendors.copy method (which will create separate instance of the data source without you having to go into the database - cleaner and MUCH faster.

Sinisa Hajnal 20-Jan-15 4:48am

I can supply you with the code for setting up combobox column, but from home. So...another 6-10 hours in the future.

yogeshysankar 20-Jan-15 5:46am

Ok...thanks alot ...
But i am working on windows application not on web application, I doesnot found RowDataBound datagridview event .

Sinisa Hajnal 20-Jan-15 5:54am

There is an equivalent. Its not the same name, but works the same

yogeshysankar 20-Jan-15 7:34am

ok.. waiting for your reply thanks a lot

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sinisa Hajnal · Accepted Answer · 2015-01-20T20:35:00

OK, here is the code for binding combobox column along with other columns.
Note two things:
- binding column name on the combobox column is the same as value member. The names are not neccessarily the same, but values should be. That is, if you're binding status list into combobox, DataPropertyName should reference column that contains status(es) in grid datasource.

- datasource for combobox column and gridview are different (this is obvious, but still to make it clear)

Calling this code from page load - if you don't know your data at that point, you can assign datasource at a later point in time - just bind the columns with column names.

VB

With dgv
               .AutoGenerateColumns = False

               .Columns(1).DataPropertyName = "quantity"

               .Columns(2).DataPropertyName = "value_type"
               With DirectCast(.Columns(2), DataGridViewComboBoxColumn)
                   .DisplayStyle = DataGridViewComboBoxDisplayStyle.ComboBox
                   .ValueMember = "value_type"
                   .DisplayMember = "value_type_name"
                   .DataSource = _source
               End With
              .Columns(3).DataPropertyName = "unit_price"


               .DataSource = ds.Tables(1)
           End With

If this helps please take time to accept the solution. Thank you.