how to group with sqldatasource define at run time

[jav]

hi, due to desing restictions, the sqldatasource's select command & connection string, must be entrer every time at run time, when i try to group a radgrid's column i have no records as result, in the other hand, when i define the sqldatasource's select command and connection string through the wizard, i have no problem to group the column, then you can help me?, what i'm doing wrong, thanks for your help. sorry for my english, i'm working on it

[Iana Tsolova]

Hello jav,

You can try setting the SelectCommand and ConnectionString of your SqlDataSource on each Page_Load and check if it makes any difference.

Furthermore, I would suggest you to use advanced data-binding for your grid as described in the following resources:

http://demos.telerik.com/ASPNET/Prometheus/Grid/Examples/Programming/NeedDataSource/DefaultCS.aspx
http://www.telerik.com/help/aspnet-ajax/grdadvanceddatabinding.html

Check it out and let me know if you need more help.

Greetings,
Iana
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[jav]

hello Iana,

thank you for answer, the links have been a great help, thank you very much