How to implement a variable lenght objectdatasource bound to a detailsview

[shnaqawi]

Dear Friends,

I have an objectdatasource which is bound to a details view. the no. of columns are variable. I could do the select function by defining a dynamic sqlSelectCommand. The problem now is that how can I have an update function for myobjectdatasource? I tried a function with variable arguments within an array but after that the objectdatasource asked for defining the parameter for the array. I don't know how to implement the update function in c#. Is there any other way to implement it?

Thanks,
-Hassan

[Frinavale]

You need to write multiple update functions.
Each update function will accept the number of parameters (with the same names as the columns) required to update the columns.

If your data source has 5 columns and you want to update all 5, then you need to write an update function that accepts 5 parameters that have the same names as your columns.

Now say your data source only has 3 columns the next time, you need to also provide an update function that accepts 3 that match the names of the columns being submitted.

The update functions will all have the same name, they will just be over loaded, each accepting a different number of parameters.

-Frinny

[shnaqawi]

Thanks for your reply.
The Numbers and Names of the columns are variable. and I have no idea that what would they be?
I'm designing an online e-training management system. the administrator would be able to add different courses along with adding a variable no. of modules for each of them. now when she associate a new trainee with a course she should also be able to add the scores of each module to the score table for that trainee. Now the problem is that I don't know what are the future courses and modules. That's why I'm looking for a solution by defining a variable length argument for the Update function.
Or maybe I should change the design totally?

-Hassan