Sql Queries to show contents of the table

Question

1.00/5 (1 vote)

See more:

Hello, I have a problem .
I have created a table in SQL called Department
which has followings departmentNames
HumanResource
ComputerScience
MBA

now i want to show these department names in combo box in visual studio 2010
??

Can any one help me ?? plz

Posted 11-May-12 7:42am

SaadZulfiqar

Add a Solution

3 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)

Wendelius · Accepted Answer · 2012-05-11T07:53:00

Solution 1

Since you didn't specify the problem more precisely, the steps could be:

fetch the data from db using SqlCommand[^] to a DataTable[^]
Set the DisplayMember[^] to proper column name
Set the ValueMember[^] if necessary (for example if you have a different key column)
define the DataTable[^] as a DataSource[^] for the combo

Posted 11-May-12 7:53am

Wendelius

Updated 11-May-12 7:55am

v2

Comments

SaadZulfiqar 11-May-12 14:01pm

Sir Department is my table name in Database
That table has a coloumn called DeptName which has following contents
HumanResource
ComputerScience
MBA

now i just want to show above contents in Combo Box using visual studio...

i m using connection less approach if u plz help me in showing the contents so can i select the depart ment names from combo box drop down(scroll)

Wendelius 11-May-12 14:03pm

But if the data is located in the database, then you fetch the data using a connection, right? After you have fetched the data into the datatable the connection isn't needed any more.

SaadZulfiqar 11-May-12 14:05pm

i will fetch using query and than store it in data set and than what to do ??

Wendelius 11-May-12 14:09pm

Then you set the datatable as the DataSource of the combobox (the last step in the list)

Maciej Los 11-May-12 14:23pm

Good answer, my 5!

Wendelius 11-May-12 17:01pm

Thank you losmac :)

Monjurul Habib 11-May-12 18:04pm

5!

Wendelius 11-May-12 18:07pm

Thanks Monjurul :)

P.Salini 12-May-12 1:16am

My 5!

Wendelius 12-May-12 4:17am

Thank you P.Salini :)

Sandeep Mewara · Accepted Answer · 2012-05-11T07:58:00

Solution 2

Use ADO.NET to get the data from database. Once you have the data in datatable, bind the department name & id to the combobox.

Look at these for ADO.NET:
MSDN: ADO.NET[^]
MSDN: Accessing Data with ADO.NET[^]

SQL Query:

SQL

SELECT 
  departmentnames,
  departmentid
FROM
  Department

Properties to use:
MSDN: ComboBox.DataSource Property[^]
MSDN: ListControl.DisplayMember Property [^]
MSDN: ListControl.ValueMember Property[^]

Posted 11-May-12 7:58am

Sandeep Mewara

Comments

Maciej Los 11-May-12 14:23pm

Good answer, my 5!

Sandeep Mewara 12-May-12 3:57am

Thanks losmac.

Wendelius 11-May-12 17:01pm

Good collection of links!

Sandeep Mewara 12-May-12 3:57am

Thanks Mika.

Monjurul Habib 11-May-12 18:04pm

5!

Sandeep Mewara 12-May-12 3:57am

Thanks Monjurul.

MaulikDusara · Accepted Answer · 2012-05-11T17:34:00

Solution 3

Hi,
Your easy and best solution here:
sp_helptext[^]

Posted 11-May-12 17:34pm

MaulikDusara