how add new column in existing datatable i added but its is come end of the bofore rows

Question

0.00/5 (No votes)

See more:

my datatable contans two columns ;

ID Value
----- -------
1 100
2 150

I want to added another column like this ,actually it is come in end of the 2 and 150
row, but I want to start from below preview;

ID Value CourseID
----- ------ ----------
1 100 1
2 150 1

please help me,
pavan

Posted 10-Sep-11 2:21am

onpavan

Updated 10-Sep-11 2:36am

DaveAuld

v2

Add a Solution

Comments

DaveAuld 10-Sep-11 8:37am

Sorry you have lost me........I think you want to add a column to the datatable, but you want it to appear before existing columns? can you confirm......

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)

OriginalGriff · Answer 1 · 2011-09-10T03:45:00

When you add your column, I assume from what you say that it is being inserted after the 2, 150 row as (for example) 3, 200.

If so, then that is not a column - it is a row. You want to add a column to the source of your database, rather than tryign to add it to the table itself.

Probably, your DataTable is loaded or bound to a Database source, to look at adding a column either in the Visual Studio Server Explorer pane, or in the appropriate database management system - Sql Management Studio for MsSql.

Mike Hankey · Answer 2 · 2011-09-10T03:48:00

It makes no sense to want to insert a row in a DataTable at a specific location as it is not visible to the user and you can visually place it anywhere you want in the control that you do use to display it as shown here where I am replacing a column in a DataGridView in a WinForms application.

ToDoManager.Controls.DataGridViewImageButtonSaveColumn col = new ToDoManager.Controls.DataGridViewImageButtonSaveColumn();
            dgvLinks.Columns.Insert(0, col);
            dgvLinks.Columns.RemoveAt(1);

but if you must place at a specific location try;

_masterTable.Columns.Add().SetOrdinal(index)

how add new column in existing datatable i added but its is come end of the bofore rows

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0