How Can I Show Foreign Key In Combo Box On Window Form C#

Question

1.00/5 (2 votes)

See more:

can anybody help me in my c# project, i have two table, customer and container, customer primary key is foreign key in container,both have separate form but no any class, now i add/det,in customer form,but i want to do same in container form, but there is combo box for customer foreign key, and it did show any data, althoug, i tried many time, but did not get any success, can anybody help me to solve this ??? i will be thanks full
this is my cod . . .

C#

private void Container_Load(object sender, EventArgs e)
        {

            SqlConnection mycon = new SqlConnection();
            mycon.ConnectionString = "Data Source=abdarkhanyousaf\\sqlexpress;Initial Catalog=REHMAN_BROTHERS;Integrated Security=True";
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = mycon;
            cmd.CommandText = "select * from container ";
            SqlDataAdapter dta = new SqlDataAdapter();
            dta.SelectCommand = cmd;
            DataSet ds = new DataSet();
            DataTable tb = new DataTable();
            dta.Fill(tb);

            customer cu = new customer();
            comboBox1.DataSource = ds.Tables["customer"];
            comboBox1.DisplayMember = ("customer_id");
            comboBox1.ValueMember = ("customer_id");
            
        }

Posted 10-Jan-16 6:36am

Member 11879814

Updated 10-Jan-16 19:58pm

v2

Add a Solution

Comments

Suvendu Shekhar Giri 10-Jan-16 12:46pm

To solve what? You haven't shared your problem.
Review the question and update accordingly.

Member 11879814 10-Jan-16 13:20pm

sir my prlbm is just, want to show data in combo box,e.g want to show customer name or key in on container form,

2 solutions

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)

DamithSL · Answer 1 · 2016-01-10T16:58:00

change your sql statement to like below

SQL

"select customer_id,customer_name from customer"

then it will load the customers from customer table. you can set value and display fields as below

C#

comboBox1.DisplayMember = "customer_name";
comboBox1.ValueMember = "customer_id";

Now your combobox will display customers names but when user select item from combobox you can get the selected value as customer id.

*dan!sh* · Answer 2 · 2016-01-10T16:59:00

Solution 2

First of all, do not show keys on screen. Show customer names instead. To do this, you will need to use a join between container and customer table. You can choose between left join or inner join based on your requirements. Your query when then return all the details for a container along with customer Id and name. In the C# code, you can then set the name as display member for customer drop down and keep the key as value member for tracking and updates etc.

Your query would probably look something like this:

SQL

select * from containers inner join customers on container.customerId = customers.customerId

You should ideally give column names to return only the data that the screen would need.

Posted 10-Jan-16 16:59pm

dan!sh

Comments

Member 11879814 11-Jan-16 2:01am

Thank u sir, good idea, but combo box still did not show any value as my code blow
private void Container_Load(object sender, EventArgs e)
{

SqlConnection mycon = new SqlConnection();
mycon.ConnectionString = "Data Source=abdarkhanyousaf\\sqlexpress;Initial Catalog=REHMAN_BROTHERS;Integrated Security=True";
SqlCommand cmd = new SqlCommand();
cmd.Connection = mycon;
cmd.CommandText = "select * from container inner join customer on container.customer_Id = customer.customer_Id";
SqlDataAdapter dta = new SqlDataAdapter();
dta.SelectCommand = cmd;
DataSet ds = new DataSet();
dta.Fill(ds);
comboBox1.DataSource = ds.Tables["container"];
comboBox1.DisplayMember = ("customer_name");
comboBox1.ValueMember = ("customer_id");

}

dan!sh 11-Jan-16 3:07am

What is returned from your query? Is there any data returned? Your dataset does not have a table called container. Replace ds.Tables["container"] with ds.Tables[0] and check what data is returned.

Member 11879814 11-Jan-16 4:08am

it show data in grid view when click on show button but not in combo box,mean i cant insert as well bcuz of no value in combo box,

dan!sh 11-Jan-16 4:09am

Did you try steps in my comment above?

Member 11879814 11-Jan-16 4:35am

yes sir i did,i also check the query on sql,work correctly, just prblm is of combo box

dan!sh 11-Jan-16 4:54am

What do you get when you do quick watch on ds.Tables["container"]? Also, are the column names in your code exactly same as what is returned by the query?

Member 11879814 11-Jan-16 5:01am

yup everything is correct in query, i replace container name by [0], give the same result, danish bhai, if you dont mind i can check to you my code table on personal mail