Datagrid view with 3330+ columns..

Hey buddies laughing is good thing but just tell me how can i create datagridview with 3300+ COLUMNS.
Got it COLUMNS not rows.. IF YOU KNOW ANS THEN POST IT . Dont laugh .

5 solutions

Solution 3

1.) you can rotate your data by exchange col and row index.
2.) you can group the data columns and transform it to a tree with columns.
happy new year ;) .

Posted 29-Dec-10 12:21pm

mbue

Comments

nitin bhoyate 1-Jan-11 6:26am

thnks But i dont know how it should be achieved can you provide example..

Solution 4

Think about this, before you get yourself fired for incompetance.

Your display is, what, 1280 pixels wide? How many of those columns do you think you can show in 1280 pixels?

Who in their right mind would want to look through 3000+ columns of data??

Simple - it's a horrible idea that has no justifiable reason for existance.

Posted 29-Dec-10 17:57pm

Dave Kreskowiak

Solution 2

You should make a custom grid for this, using , also i belive u want just store data and not display all 3k columns as output ?

Posted 27-Dec-10 4:44am

Jason Ti

Solution 5

Hi
You can create dynamci column shown as below.

DataTable dt = new DataTable();
for (int i = 0; i < 10; i++)
{
dt.Columns.Add(i.ToString());
}
for (int i = 0; i < 5; i++)
{
DataRow dr = dt.NewRow();
for (int j = 0; j < 10; j++)
{
dr[j] = j;
}
dt.Rows.Add(dr);
}

GridView dv = new GridView();
dv.DataSource = dt;
dv.DataBind();

Posted 29-Dec-10 18:25pm

priyapavithra

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)

OriginalGriff · Accepted Answer · 2010-12-27T04:01:00

Don't.

To put it in more detail: Don't do it. Think about it from a user point of view. How useful is a DGV with over 3000 columns? How long will it take a user to find the column he is interested in? Bearing in mind that a DGV column has a default width of 100 pixels, a screen running 1680 pixels wide will be able to show 16 columns at a time - then the user will have to scroll. Through all 200 horizontal pages.

Show them less info, but give them an option to see more detail for a particular row, preferably in a tabbed form with items logically grouped.