how to get column name from mysql

Question

0.00/5 (No votes)

See more:

Hi,

I have query which retrieves columns from 4 tables using join statement.Now I want to store the column name or alias name of the field name of that query.please help me how to retrieve them?

Example If I have table called A,B,C which have columns like Aa,Ab,Ac,Ba,Bb,Bc,Ca,Cb Respectively then in join statement I`l retrieve Aa,Bb,Ca,Cb

Now I want to save Column name Aa,Bb,Ca,Cb

Posted 19-Aug-12 18:18pm

Mukunda Raj

Updated 19-Aug-12 18:43pm

v3

Add a Solution

Comments

_Amy 20-Aug-12 0:20am

What is your result? DataTable or DataSet? Or some scalers?

Mukunda Raj 20-Aug-12 0:26am

Example If I have table called A,B,C which have coloumns like Aa,Ab,Ac,Ba,Bb,Bc,Ca,Cb Respectively then in join statement I`l retrieve Aa,Bb,Ca,Cb

Now I want to save Coloumn name Aa,Bb,Ca,Cb

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)

**AmitGajjar** · Answer 1 · 2012-08-19T18:53:00

Solution 2

Hi,

If you are executing your query and your result is in form of DataSet the you can get each column name using DataColumn

Please check this[^] discussion, you can find your answer from there.

Let me know if you are not storing your query result in DataSet.

Good luck

Thanks
-Amit Gajjar

Posted 19-Aug-12 18:53pm

AmitGajjar

Comments

Mukunda Raj 20-Aug-12 1:45am

In that discussion,what is ds,tables[0]?

DropDownList1.DataSource = ds.Tables[0].DefaultView;

AmitGajjar 20-Aug-12 1:53am

ds is your DataSet.

Mukunda Raj 20-Aug-12 2:16am

Thanks i found solution!!

string[] columnNames = dtGrid.Columns.Cast<datacolumn>().Select(x => x.ColumnName).ToArray();

This is what actually I was looking for.

AmitGajjar 20-Aug-12 2:26am

Mark Solution as answered if it helps you, it will help others to know correct answer.

Mukunda Raj · Answer 2 · 2012-08-19T20:16:00

Solution 3

string[] columnNames = dtGrid.Columns.Cast<datacolumn>().Select(x => x.ColumnName).ToArray();

Posted 19-Aug-12 20:16pm

Mukunda Raj

RAKESH CHAUBEY · Answer 3 · 2012-08-19T18:20:00

Solution 1

PLz Explain a little More , . Check For into in u query Plz Explain .

Posted 19-Aug-12 18:20pm

RAKESH CHAUBEY

Comments

_Amy 20-Aug-12 0:22am

This is not an answer. Please ask the your doubts in comments.

RAKESH CHAUBEY 20-Aug-12 0:30am

k