Modifying asp:Table Columns dynamically


I need to create an page with c# code behind that will modify 4 columns of a table dynamically every about 10 minutes or so. The table itself will have about 1100 rows in it and about 27 columns of data

The static data on the table will be pulled from a database and the dynamic data will be created and sent from the c# code behind file.

I am thinking that I can use asp:UpdatePanel and a timer to update the table but logistically I need to figure out how to implement the table so the code behind file knows to update only the columns needed.

Any ideas?

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bob LearnedCommented:
Is there a reason that you aren't using the GridView to generate the table?
TimAuthor Commented:
Hi Bob,

I am using oledbadapter and DataTable ( TableRows and TableCells ) to grab the data from the DB and fill in the table programmatically

The table itself is defined in the aspx file and I fill in the TableRows and TableCells programmatically.

The DB is an Access DB not SQL fyi, not sure if that makes a difference.

I didnt use GridView because I had previous used oledb to show the DB on the page so thats what I went with.

Would GridView allow me to meet my goal easier?

Bob LearnedCommented:
Hmmm...let's see:

1) You can show/hide columns with a minimum of code

2) GridView and SqlDataSource talk to each other, and allow for sorting and paging without any code

3) You can apply styling (both attributes and CSS) to the GridView.

4) The GridView controls handles all the HTML generation, like scroll bars, rows, cells, etc.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.