How do I read the column names of a table into a combobox

Question

0.00/5 (No votes)

See more:

C#

I have a question. I need to have the rows of a table displayed as the list-elements of a combobox Actually I have a table called 'Table1' with two columns *Id* and *Name* and i need to have a combobox that once the form loads can read these column names as the elements of the combobox so if a search needs to be performed on the table, a choice can be done as per what column value. But when the form loads the combobox is empty

Please find my code below:

What I have tried:

C#

string sd = @"select * from AcquiredBulkInfo";
            SqlConnection con = new SqlConnection(MyConnectionString);
            SqlCommand cmd = new SqlCommand(sd, con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);
            comboBox1.DataSource = dt;

Posted 9-Nov-16 1:45am

Nganku Junior

Updated 16-Nov-16 7:31am

Add a Solution

3 solutions

Solution 1

Look at the DataTable.Columns property. It's a DataColumnCollection of DataColoumn items, and you want the DataColumn.ColumnName property.

Posted 9-Nov-16 1:50am

#realJSOP

Updated 9-Nov-16 1:53am

v2

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)

Karthik_Mahalingam · Accepted Answer · 2016-11-09T02:09:00

Solution 2

try this query

SQL

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'AcquiredBulkInfo'

Posted 9-Nov-16 2:09am

Karthik_Mahalingam

v2

Comments

#realJSOP 9-Nov-16 8:59am

Why hit the database again? He has all the info he needs in the datatable object.

Nganku Junior 9-Nov-16 12:20pm

@John Simmons : The purpose behind my 'gymnastics' is so I can enforce search criterion based on column name

Karthik_Mahalingam 9-Nov-16 23:17pm

he just need to bind the column names in the combobox, so there is no point of bringing the entire data to the application just for showing the column names.

Nganku Junior 11-Nov-16 3:09am

Hey when I use this code:
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'AcquiredBulkInfo'
The datagridview displays ;
System.Data.DataRowView
What is lacking please

Karthik_Mahalingam 11-Nov-16 4:06am

datagridview or combobox?

Nganku Junior 16-Nov-16 13:15pm

Combobox thankyou

Karthik_Mahalingam 16-Nov-16 21:33pm

ComboBox1.DisplayMember = "column_name";

Nganku Junior · Accepted Answer · 2016-11-16T07:31:00

C#

void Search_Crit()
           {
           string sd = @"SELECT COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME= 'AcquiredBulkInfo'";
           SqlConnection con = new SqlConnection("connection string");
           con.Open();
           SqlCommand cmd = new SqlCommand(sd, con);
           SqlDataReader dr;
           dr = cmd.ExecuteReader();
           if (dr.HasRows)
               {
               while (dr.Read())
                   {
                   comboBox1.Items.Add(dr[0].ToString());
                   }
               }
           dr.Close();
           con.Close();
           }