bind 1 gridview according to 4 sql queries dynamically

Question

hi  i have a situation where i have to display a grid view in popup but problem is that i have 4 different sql queries but only 1 gridview.so how can i display gridview according to the query dynamically.   please anyone help me to solve my problem.

nirjharini pradhan · Answer

Actyally what my requirement is i have 1 popup, inside popup 1 gridview is there.what i need is i have 4 search button.if i click on 1st search button it should display table1 in gridview.as soon as i click on 2nd button then the grid view should bind according to 2nd table.like that will continue for remaini 2 tables.

Manas Mohapatra · Answer

You can do it in Database level or Application level.   Database:   I am not sure about your four queries.  If all queries returns same data structure(same column names) then you can use UnionALL to combine all queries.   select id, name from tab1   unionall   select id, name from tab2    Application level   If you are not able do it database , implement logic in coding level. I hop you will get multiple result sets. Create an entity(class file with required properties) and add one by one resultsets. Next bind the entity to your gridview.