We're a community of 1076K IT Pros here for help, advice, solutions, professional growth and fun. Join us!
1,075,809 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Start New Discussion Reply to this Discussion

I need advice ,, error with combobox have Parameters in DataGrid

hi
The idea is to make DataGrid contains a field of type combobox it have another data source to choose from those and save data in the DataGrid , this is possible and without any problems..
But when make Parameters to filter data in the combobox and when i try add records have different Parameters ,, error will appears.
An example may not be logical, but I hope that shows what I mean

link: https://rapidshare.com/files/2458729470/FilterComboBox.zip

thank

2
Contributors
8
Replies
2 Days
Discussion Span
5 Months Ago
Last Updated
9
Views
ebrahim1
Newbie Poster
6 posts since Nov 2012
Reputation Points: 0
Solved Threads: 0
Skill Endorsements: 0

In the future, please "clean" your project/solution before compressing and uploading.
It saves everyone time and diskspace...

john.knapp
Posting Whiz in Training
221 posts since Oct 2012
Reputation Points: 25
Solved Threads: 22
Skill Endorsements: 3

My first piece of advice is to turn on "Option Strict"
Right-Click Project in Solution Explorer -> Select Properties (last item on context menu)
Select Compile Tab -> "Option Strict" -> click dropdown and select "On"

Rebuild your application, resolve those 2 errors regarding implicit type conversions and see what happens.

john.knapp
Posting Whiz in Training
221 posts since Oct 2012
Reputation Points: 25
Solved Threads: 22
Skill Endorsements: 3

Mr.john.knapp thank you to your advice, i do it. but the error still exists.

ebrahim1
Newbie Poster
6 posts since Nov 2012
Reputation Points: 0
Solved Threads: 0
Skill Endorsements: 0

I'll let you know what I find

john.knapp
Posting Whiz in Training
221 posts since Oct 2012
Reputation Points: 25
Solved Threads: 22
Skill Endorsements: 3

Mr.john.knapp ,, Thanks again, but you can solve the error

ebrahim1
Newbie Poster
6 posts since Nov 2012
Reputation Points: 0
Solved Threads: 0
Skill Endorsements: 0

The error I see is DataGridViewComboBoxCell value is not valid, is that the same error you get?

The default error message also says to handle the data error event, did you do that? If not, add this code to Form1.vb

Private Sub StudentsDataGridView_DataError(ByVal sender As Object, _
                                          ByVal e As DataGridViewDataErrorEventArgs) _ 
                                           Handles StudentsDataGridView.DataError
    If e.Exception IsNot Nothing Then
        MessageBox.Show(e.Exception.Message, e.Exception.Source)
    End If
End Sub
john.knapp
Posting Whiz in Training
221 posts since Oct 2012
Reputation Points: 25
Solved Threads: 22
Skill Endorsements: 3

From what I see in a Google Search using that error, and in particular this discussion, it appears to be an issue with the way your data is bound to the DataGridView.

john.knapp
Posting Whiz in Training
221 posts since Oct 2012
Reputation Points: 25
Solved Threads: 22
Skill Endorsements: 3

Mr.john.knapp i ded not handle error so i will add the code i think it will be handle it.
thank you so much

ebrahim1
Newbie Poster
6 posts since Nov 2012
Reputation Points: 0
Solved Threads: 0
Skill Endorsements: 0

This article has been dead for over three months: Start a new discussion instead

Post: Markdown Syntax: Formatting Help
 
You
 
© 2013 DaniWeb® LLC
Page rendered in 0.0788 seconds using 2.67MB