How to concate column with rows using windows application in asp.net with C#

Question

0.00/5 (No votes)

See more:

Student English Tamil Maths Science Social

A 70 75 80 90 75
B 60 55 70 85 60
C 50 60 70 75 63

using foreach loop, from the above Datagridview i want as follows
how can i do please help me

A Englsih 70,Tamil 75,Maths 80,Science 90,Social 75
B Englsih 60,Tamil 55,Maths 70,Science 85,Social 60
C Englsih 50,Tamil 60,Maths 70,Science 75,Social 63

how can i do in asp.net using C#.

Regards,
Narasiman P.

Posted 3-Dec-13 15:45pm

Member 8054539

Add a Solution

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)

ArunRajendra · Answer 1 · 2013-12-03T16:40:00

Solution 1

Might be this reference will give you some head start.

http://stackoverflow.com/questions/8853276/c-sharp-custom-formatting-a-datagridview-columns-displayed-data-without-changin[^]

Posted 3-Dec-13 16:40pm

ArunRajendra

Tejas Sawant 13 · Answer 2 · 2013-12-03T21:31:00

I used this code to flip data ,column as rows ,may this idea will help you in windows application using c#

C#

Globaldata.SQLQuery = "select * from table" 

           

            OdbcDataAdapter first = new OdbcDataAdapter(Globaldata.SQLQuery, con);

            DataTable oldTable = ds.Tables.Add("first");

            first.Fill(ds, "first");           

            DataTable firsttable = new DataTable();

            firsttable.Columns.Add("Parametere");
            for (int i = 0; i < oldTable.Rows.Count; i++)
                firsttable.Columns.Add("Values"+i);

            for (int i = 0; i < oldTable.Columns.Count; i++)
            {
                DataRow newRow = firsttable.NewRow();

	            newRow[0] = oldTable.Columns[i].Caption;
	            for (int j = 0; j < oldTable.Rows.Count; j++)
		            newRow[j+1] = oldTable.Rows[j][i];
                firsttable.Rows.Add(newRow);
            }

            ds.Tables.Remove(oldTable);
            ds.Tables.Add(firsttable);