[Solved] to get the filtering work.

[Esperanza Ramos]

Hi, All:

I am using the Ajax Rad Grid, with SqlDataSource.  In the stored procedure
for select, I put:
     select from MyTable ... order by column1, column2, ...., column9.

Then, in my Rad Grid, I set:
         AllowFilteringByColumn="true"

But this does not work properly.  When I use the filter inside Rad Grid, it did not work as expected.

Please help.

Stanley Huang

[Shinu]

Hi Stanley,

How are you binding the Grid? Try binding the Grid in the NeedDataSource event. Grid features like Filtering,Sorting etc work with AdvanceDataBinding techniques.
Advanced data-binding

Shinu.

[Esperanza Ramos]

Hi, Telerik Team:

Thank you for your link.  I visited the link.
Here is how I bind my rad grid:

protected override void OnLoadComplete(EventArgs e)
{
base.OnLoadComplete(e);
IDCollection IDs = Session["MyRecords"] as IDCollection;
sdsRGrid.SelectParameters[0].DefaultValue = (IDs == null) ? "" : IDs.ToString();
rgJobInv.DataSourceID = sdsRGrid.ID;
}

In the Rad Grid, I need to have auto-update, auto-retrieve, auto-delete. In my understanding,  I need to bind rad Grid to SqlDataSource:
       RadGrid1.DataSourceID = SqlDataSource1.ID; 

Can I have both auto-update, auto-select, auto-delete and filtering features work at the same time? Please give some details on how to implement that.

Thank you so much.

Stanley Huang

[Princy]

Hi Stanley,

Go through the following links.

Automatic operations
Automatic operations with SqlDataSource control
Update/Insert/Delete with stored procedures and SqlDataSource control

Princy.

[Esperanza Ramos]

Hi, Telerik Team:

My question is:
   
           How to get the filtering feature work, with auto-operations(update, select, delete)?

Currently, I have the auto-operations(update,select..) working, But I don't have the filtering work in my Ajax Rad Grid.

Currently I bind the Grid as:
 
      RadGrid1.DataSourceID = SqlDataSource1.ID;

Please help:
   How to get the filtering working, while auto-opetation(update..) are working as well.

Stanley Huang