implementation suggesion for a customized list page

Question

1.00/5 (1 vote)

See more:

hi,
this is not a question related to any code.i know there are very experienced and genius
programmers out there all i need is a suggestion.

im developing a list page which has more than 20 columns.i know its bit long.so i want to make it more flexible,the idea is..i want the user to select which columns they need to see in the list.n based on their selection data must be bring back from the back end(only
the selected columns).we have a very huge database so.i want to make very optimized request..please suggest a best way to implement this..

Posted 18-Dec-14 18:28pm

NowYouSeeMe

Add a Solution

Comments

DamithSL 19-Dec-14 0:31am

you specify language as c# but what is the technology like winform/wpf or..?

NowYouSeeMe 19-Dec-14 0:38am

actually its a web application..mvc4 to be specific

BillWoodruff 19-Dec-14 0:37am

I can see doing this a variety of ways, including switching between two "views" of your list-grid: a column selection view, and then, when columns are selected, a view where the not-selected columns are hidden, or folded, or whatever.

There are several excellent Controls on CodeProject (for WinForms) that would let you do this easily, and I imagine there are similar Controls here for WPF (or ASP ?).

If you give more details, I will respond further.

NowYouSeeMe 19-Dec-14 0:45am

its a web application(mvc4)..the thing is i want to generate a sql query based on that selected column only..is it possible to dynamically change queries based on selection..i mean im talking about 20 check boxes with the colmun names..!!

BillWoodruff 19-Dec-14 5:32am

If it's a web app using MVC: not my area, sorry. But, what you describe sounds quite possible.

[no name] 19-Dec-14 1:43am

This mean you will have to do manual binding from your select statement based on the selected fields.
Or better still you can set the SelectCommand of the SqlDataSource populating the GridView.

1 solution

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)

Raul Iloc · Answer 1 · 2014-12-18T19:53:00

Here are some steps:

1. Each of your 20 database columns must be associated with a flag that have to be set or cleared if that column was selected or not. To implement this the best way is by using a bits field, so you will need a new column for storing the value of the bit fields. For more details about managing bits fields see the next article: Masks and flags using bit fields in .NET[^]

2. When the user will select and/or deselect a set of columns ==> the associated flags have to be updated (from false to true or viceversa) by using the logic from the 1st point above, then the new value of the "bits field" column must be stored in the database.

3. Your used UI control (Grid, ListView, table, etc) have to be generated dynamically in your view by using razor code and by checking the "bits field".

4. Because you are using a huge database, you must implement pagination to speed up the loading and the user iteration with your application.

PS: You could search for pagination articles on the web and you could have a look also on my articles about MVC, jqGrid and pagination.