combobox behaves differently if used in datagrid and in details?

Question

2.00/5 (1 vote)

See more:

Hi all

I'm using VS 2008 and vb net

I have two tables in access 2003 database (for simplicity)
table tblGroups with groupId and groupDescription (groupId primaryKey)
table tblUsers with username, userFullName and groupId (username primaryKey)
tblUsers.groupId is in relation with tblGroups.groupId

I created a dataset with these two tables

If I create using drag and drop from dataset a datagridview of tblUsers table, I can fix the column as a combobox idGroup to show me groupDescription and save groupId.

If I create using drag and drop from dataset a detail of tblUsers, if I fix the column as a combobox to show me groupDescription and save idGroup, I try to save record but I have error because I have that system tries to save groupDescription.
Settings of combobox are exactly the same.

I don't understand what's wrong.
I can send a small example of a solution with database and everything on request.

Many Thanks

Lawrence

Posted 7-Apr-12 0:36am

nibbio1971

Add a Solution

Comments

Shahin Khorshidnia 7-Apr-12 13:33pm

I didn't understand your intention.

nibbio1971 12-Apr-12 3:00am

my intention is "show the description of the group instead that the id of the group. I can do this in datagrid but not in details"

Shahin Khorshidnia 12-Apr-12 10:17am

Sorry, it's still unclear! And you see, nobody has answered it since 5 days ago, because of the vagueness!

nibbio1971 13-Apr-12 2:29am

Believe me that i'm not able to be clearer. I've read more and more the question to realize what it's unclear but, as usual when you read things you have written, i find it clear.
do you want me to send you a complete solution with the problem?
205kb rar format
if you want to do so, I don't ask your email, but mine is ...
if you write me here, i send you the solution
thanks
Lawrence

Shahin Khorshidnia 13-Apr-12 4:37am

I believe you but I'm not sure I'm capable of helping like that.

Let's hope somebody else will understand the intention.

But if I were you, I'd remove my email address from the comment.

nibbio1971 13-Apr-12 4:59am

Thanks anyway, if you change your mind, send me a message, you have email (now of course i'll delete it), or write me here
g'day

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)