how to get data from access database into combobox using c#

Question

1.00/5 (3 votes)

See more:

hi m not able to get data from access database into combobox when i click on it .....i juzz want to get one column in combobox...plzz help

Posted 25-Oct-12 8:28am

Member 8746257

Add a Solution

Comments

joshrduncan2012 25-Oct-12 14:40pm

What have you tried so far? Can you show us your attempt at getting this accomplished?

Sergey Alexandrovich Kryukov 25-Oct-12 15:00pm

Not a question. Can you ask one?
--SA

Sandeep Mewara 25-Oct-12 15:25pm

This is not a well framed question! We cannot work out what you are trying to do/ask from the post. Please elaborate and be specific.
Use the "Improve question" link to edit your question and provide better information.

fjdiewornncalwe 25-Oct-12 15:56pm

Let's see what you have tried so that we have a starting point.

2 solutions

Solution 2

page_load
{
oledbconnection con =new oledbconnection(connectionstring);
con.open();
oledbdataadaptor adp=new oledbdataadaptor("select columnname from tablename",con);
dataset ds =new dataset();
adp.fill(ds,"tabname");
combobox1.text=ds.tables["tabname"].itemarray[0];

}

Posted 25-Oct-12 18:57pm

Nagaraja1986

Comments

Member 8746257 26-Oct-12 16:10pm

hiee

i tried this bt its showing an error 4 dat ...."itemarray[0]" thing
in following line
combobox1.text=ds.tables["tabname"].itemarray[0];

error is:
Error 2 'System.Data.DataTable' does not contain a definition for 'itemarray' and no extension method 'itemarray' accepting a first argument of type 'System.Data.DataTable' could be found (are you missing a using directive or an assembly reference?)

c if u can help in dat...
thnx in advance

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)

mhd.sbt · Accepted Answer · 2012-10-25T10:27:00

Solution 1

hello

you can get your column by this step:

1-click on your combobox and go to comboboxTask
2-choose your data source(access database and your table)
3-choose your column that your want display in combobox, in Displaymember
4-run your Application

i hope this will be useful

Posted 25-Oct-12 10:27am

mhd.sbt

Comments

Member 8746257 26-Oct-12 16:00pm

hiee

i tried this bt getting t following error....

ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

c if u can help in dat....
thnx in advance

mhd.sbt 27-Oct-12 1:52am

in "dataSourceConfiguration Wizard" and in "Choose your database connection" step you should be Select New connection and from open window select "Microsoft Access Database file" and click ok.
from this window you should be select your access database and then and continue next step...

Member 8746257 28-Oct-12 9:04am

hiee

thnx alot ...it worked like heaven.....:)