Dynamic Gridview vs Static Gridview asp.net

Question

0.00/5 (No votes)

See more:

Hi,
I have a requirement to display data from the lookup tables in SQL database on to a gridview in asp.net. I have around 17 lookup tables in the db. Structure of the tables are same, just that, the column names are different for each lookup table.
As of now, i am creating and binding the grid dynamically. The edit, update , delete functionalities are also implemented in code behind.
Just wanted to know, if dynamic grid is a good design for the above situation or should i bind 17 different static gridviews to the lookup tables.
Which one would be a better design in terms of performance.?

Any help appreciated...thanks..

Gaurav

Posted 23-May-13 22:14pm

gaurav mishra 07

Add a Solution

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)

RelicV · Answer 1 · 2013-05-24T00:01:00

Hi Gaurav,

Always a dynamic grid takes time to load the data as it has to create the grid itself in the run-time. So, a static grid would be better in terms of performance levels.

As you have mentioned there are 17 lookup tables in your DB with same schema but with different column names, I would suggest you to use a single static grid.

My suggestion is to get the lookup table names into a Dropdownlist. On selecting the required lookup table, you can maintain a single static grid with CURD functionality.

Loading 17 different static/dynamic grids in a single page is also not a good idea.!

The logic here is you get the required lookup table with 'ID' as first column and 'Description' as second column. Even if the column names are different, just use the alias name in the DB to get the data.

Thank you,
Vamsi

gaurav mishra 07 · Answer 2 · 2013-05-24T02:33:00

thanks a lot Vamsi...that is exactly what i am doing.
I have one grid defined in my aspx page and i am binding it on runtime on the basis of a look up id.
I am looping over all the column names in the dataset and creating a bound field for the static grid, in the code behind.

Thanks,
Gaurav

Dynamic Gridview vs Static Gridview asp.net

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0