populate combobox in c# with access database

Question

0.00/5 (No votes)

See more:

SQL

SELECT InvoiceDetails.ItemId, Item_master.item_code
FROM (InvoiceDetails INNER JOIN [Transaction] ON InvoiceDetails.Trans_id = Transaction.Trans_id) INNER JOIN Item_master ON InvoiceDetails.ItemId = Item_master.Item_id where (((Transaction.invoice_no)='" + txt_invoice.Text + "'))

I use this query for getting special data.

I want to display ItemCode in ComboBox.

Posted 31-Jul-13 0:30am

Ashutosh_jha

Updated 31-Jul-13 1:15am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v3

Add a Solution

Comments

IpsitaMishra 31-Jul-13 6:32am

Where are you getting the problem?

Ashutosh_jha 31-Jul-13 6:37am

how i populate combobox using this query.

Maciej Los 31-Jul-13 7:02am

What you mean? What have you done till now? Where are you stuck?

Ashutosh_jha 31-Jul-13 7:06am

I want to populate Combobox with ItemCode. getting ItemCode by searching via query.

[no name] 31-Jul-13 7:17am

Okay so go ahead and do that. "I want" and not a question or description of a problem. Where is the code that you have written to populate the combobox? What is the problem with your code?

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 31-Jul-13 7:48am

Please check and accept this answer, if it has helped you in any way.
This will help others to find the answer in one go and you will also be awarded with some points for this action...

Thanks,
Tadit

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 1 · 2013-07-31T01:30:00

Solution 2

Refer - Fill Combobox from database[^].
It has a code snippet explaining how to Bind the ComboBox.

So,

Create a Connection
Get the data by query
Fill to a DataSet
Assign appropriate DataSource, DisplayMember and ValueMember for the ComboBox

Posted 31-Jul-13 1:30am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

IpsitaMishra 31-Jul-13 7:47am

Nice Explanation TaditD :)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 31-Jul-13 7:49am

Thanks a lot Ipsita... :)

Dheeraj_Gupta · Answer 2 · 2013-07-31T01:23:00

Use ADO.Net disconnected mode for this.

1) create databse connection object
2) create dataadapter object and dataset object.
3) create sql command object and perform the dataadapter's Fill method for dataset object.
4) Now you have data in dataset's table.
5) bind the combo box's data source property to this table.

C#

this.comboBox1.DataSource = dataSource;
this.comboBox1.DisplayMember = "Name";
this.comboBox1.ValueMember = "Value";

// make it readonly
this.comboBox1.DropDownStyle = ComboBoxStyle.DropDownList;

Please Mark as Answer if suffice your query.

Regards,
Dheeraj Gupta