Dynamic Datasheet

[keirnus]

Hello

I would like to ask some advice and suggestions on something.

I have a data in a table format. But new columns can be added.
I was thinking of using Datasheet because it is capable of editing data
directly in the cell. Since new columns can be added, a column with its
column name will be added. The column of the datasheet is dynamic enough
when there's a new column.

What's the best way of implementing this?
Use an SQL query for addling new column to the table?
Is there any better ways to implement this?

-keirnus-

[maxamis4]

How good are you with code?

I could give you a piece of code that can do this for you?

Let me know?

[missinglinq]

@keirnus
I think the first order of business here is explaining exactly what you mean by this statement. Do you mean that you want the end users to be able to add columns?

Linq ;0)>

[keirnus]

@maxamis4
You can give me the code.
I will try.

[keirnus]

@missinglinq
Seems like "yes"...the columns are the workers in a certain project.
Let's say "Painter", "Helper", etc. These are the headers in a column.
Data in the column are numbers of workers per row.

There are times when new workers are added in the list.
So, there will be new columns for the new workers.

What's the best way to handle this number-of-workers matter?