Post reply

Database design for saving filter settings of a asp.net grid view

  • April 12, 2012 at 9:12 am

    #259050

    Hi,

    I have to save filter settings of a Grid View in to database , Grid contains 10 columns.

    1.I will send entire result set to the UI, and will bind it to Grid and all filters are enabled.

    2.Now I have to save the filter settings <Filters in Excel> to the database , based on user selections as next time user visits screen have to retain all filter settings that were made.

    Please suggest me the best approach as part of database designing for saving and retrieving information.

  • April 12, 2012 at 12:15 pm

    #1472850

    That depends on how the filters work. If they create a T-SQL statement, you could create a varchar(max) column, or state a suitable size, and put the query in that column.

    If the filtering is from component values in the UI, you could do the same, but create a string that includes the component name(s) and value(s). Then parse the string whent he screen is opened later and set the appropriate values.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply