dynamic datasourse for GRID

Question

Wanna change GRID datasource via radiobutton. i have 2 datasource,2 view and 1 grid. with radiobutton wanna switch grid datasource.

Accepted Answer

1	Also, with version 1.2, it will be possible to set the runtime query of a datasource. link answered 06 Dec '12, 01:12 Ugur Kocak ♦ 561●6 accept rate: 23% Gozumuz karaldi. Ne zaman eni version chikacak? (06 Dec '12, 01:28) lezgin

Answer 2

0

Hi Zamir,

You can create a third view union of two view as follows:

Create view3 as
Select view1.*, 1 view_nr
from view1
Union all
Select view2.*, 2 view_nr
from view2

Then, query view3 with view_nr column:

Select *
from view3
where view_nr = 1 -- or 2

link

answered 06 Dec '12, 01:09

Ugur Kocak ♦
561●6
accept rate: 23%