datagridview combobox cell value is not valid C# || Solved 100 %

[@miltoneduardoespinoza4320]

Great, i spend lot of time looking for the answer, Thanks so much

[@23BrotherWolf]

Great!!!! Work for me!

[@emqudrummer]

Dude, you safe ma life ^_^. I've been looking for this solution but got no idea

[@abbasthegreat5]

you are welcome.
Regards:
E-Learning Portal

[@yairkatz9443]

Thank you! been working on this problem for hours

[@gustaneviomangue]

Sir, u saved my life, thanks

[@medmeskine2762]

thank u so much for solving us this problem

[@zyad_mz9238]

Thank you for that 😊☺️

[@tmhchacham]

Checking the error text is not a great idea, as it might change. Instead, use the Context property of the DataGridViewDataErrorEventArgs parameter to check for the appropriate DataGridViewDataErrorContexts. For example, in VB:
AddHandler [DataGridView].DataError, Sub(Sender As Object, Arguments As DataGridViewDataErrorEventArgs) If Arguments.Context = DataGridViewDataErrorContexts.Formatting + DataGridViewDataErrorContexts.PreferredSize Then .Cancel = True

[@jimrobertson6959]

Thank-you. This helped me greatly!

[@sanjivchauhan2773]

Thanks a lot. It worked for me. Thanks again

[@abbasthegreat5]

Welcome

[@nabeelbin-hamdain5396]

problem can be solve easily by making sure the data you trying to fill in are exactly match the data in COMBOBOX in length and data (Space is consider )

[@dickwoodman7814]

Explain more, you idiot.

[@attininolmodammir1512]

@@dickwoodman7814 LMAO u calling him an idiot when is sefinetly right , he gave a simple explanation , the value inside the combobox needs to match a value of its items u dumb fucktard

[@spisebanan]

Thanks! This was very helpfull.

[@diegospinedi8417]

Great! is too much!!! i solved my problem!!!

[@TimmyThings]

the values are not showing in combobox ! :|

[@gamingkidunia6002]

if (e.Exception.Message == "DataGridViewComboBoxCell value is not valid.")
{
object value = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value;
if (!((DataGridViewComboBoxColumn)dataGridView1.Columns[e.ColumnIndex]).Items.Contains(value))
{
((DataGridViewComboBoxColumn)dataGridView1.Columns[e.ColumnIndex]).Items.Add(value);
e.ThrowException = false;
}
}

[@sharehackfree]

Good video

[@matheusperrotperrot4002]

Hi were is the data in the comments?

[@abbasthegreat5]

There is no need to enter any data.
Just generate the Data Error event of DataGridView.

[@احمدبلو-ه3ت]

great.. where is the code in the comments plz

[@ahmedal-tayeb6793]

good job

[@vuminkosivincentmatibe3216]

thank you sir

[@abbasthegreat5]

Welcome

[@mickantonio245]

Thanks

[@jetrogadiane3713]

Where can i find the dataerror in vb.net

[@aparnaappu5195]

thanks you

[@appiah212]

Please kindly help with VB.net version

[@augustinmca1620]

didnt found ur coding under the comments

[@abbasthegreat5]

Augustin MCA Good point. But Actually there is no need to paste any code there.
Just create the event i mentioned in the video and your issue will be resolved simply.
Regards:
E-Learning Portal

[@augustinmca1620]

Issue is cleared. Its Worthy

[@peterashraf2266]

I think the code will be like this :
Using vb.net Language :
If (TypeOf (e.Exception) Is ConstraintException) Then
Dim view As DataGridView = CType(sender, DataGridView)
view.Rows(e.RowIndex).ErrorText = "an error"
view.Rows(e.RowIndex).Cells(e.ColumnIndex) _
.ErrorText = "an error"
e.ThrowException = False
End If
Using c# Language:
if ((anError.Exception) is ConstraintException)
{
DataGridView view = (DataGridView)sender;
view.Rows[anError.RowIndex].ErrorText = "an error";
view.Rows[anError.RowIndex].Cells[anError.ColumnIndex].ErrorText = "an error";
anError.ThrowException = false;
}

[@augustinmca1620]

for c#
private void dgwcarpentry_DataError(object sender, DataGridViewDataErrorEventArgs e)
{
if (e.Exception.Message != "")
{
object value = dgwcarpentry.Rows[e.RowIndex].Cells[e.ColumnIndex].Value;
if (!((DataGridViewComboBoxColumn)dgwcarpentry.Columns[e.ColumnIndex]).Items.Contains(value))
{
((DataGridViewComboBoxColumn)dgwcarpentry.Columns[e.ColumnIndex]).Items.Add(value);
e.ThrowException = false;
}
}
}
//dgwcarpentry(dataGridView1)

[@PenTol2Kub]

Than you.
I'm Test with vb.net Language.
It work.

[@abbasthegreat5]

//This event is used to avoid the error of DataGridviewCombobox Cell
if (e.Exception.Message == "DataGridViewComboBoxCell value is not valid.")
{
object value = grdPurchaseQMaster.Rows[e.RowIndex].Cells[e.ColumnIndex].Value;
if (!((DataGridViewComboBoxColumn)grdPurchaseQMaster.Columns[e.ColumnIndex]).Items.Contains(value))
{
((DataGridViewComboBoxColumn)grdPurchaseQMaster.Columns[e.ColumnIndex]).Items.Add(value);
e.ThrowException = false;
}
}

[@harryhasson5388]

Hithe line ((DataGridViewComboBoxColumn)dataGridView.Columns[e.ColumnIndex]).Items.Add(value);fails. because ausing error: items cannot be modified when dataSource is set

[@abbasthegreat5]

yes, You cannot modify the value of any DatagridviewColumn or Cell if you have assigned a datatable to your DataGridView.
So, Do one thing. email your project on my email:
[e-mail]
I will resend it you after correcting the error.
But if you are not able to send me. Then do this:
Populate your DataGridView by assigning values to each row by using k loop(for or foreach)
for(int i=0; i

[@saeedizadi4369]

ای خدا پدرتو بیامرزه دهنم صاف شده بود با این ارور