cannot bind gridview to a second sqldatasource programatically

[hassanmohamed]

Hi at run time i bind gridview to sqldatasource1 at some point. when i try to change datasource to sqldatasource2 at another point i get error. in many other occasions i found it is impossible to change datasource for a gridview any attempt to change will cause problem as if gridview has been corrupted

[Anand Desai]

Use loaded DataSets to load your grid at runtime. It seems very easy

Anand Desai Developer Atharva Infotech

[hassanmohamed]

what??!!!can you explain a little bit

[vaseeem]

use dataset in code. gridview.datasource=dataset

Errors are like Mini Skirts, shorter they get, more revealing they become.

[hassanmohamed]

but i found people use 2 sqldatasources to bind to gridview alternatingly..my experience with such endeavour was absolute failure..i dont know why. yes i can do the dataset option