Intersoft Community - WebGrid Enterprise - WebGrid and ISDataSource Filtering issue

WebGrid and ISDataSource Filtering issue

handy@intersoftpt.com — Tue, 13 Dec 2011 03:18:36 GMT

Hello Jim,

Yes, We understand. But WebGrid has its own mechanism. If you want, you can filter or bind by using WebCombo or others control as parameter. I send you my sample include how to modify sorting from javascript.

Regards,
Handy

WebGrid and ISDataSource Filtering issue

jdresser@idexcorp.com — Thu, 08 Dec 2011 07:58:17 GMT

Thanks for your response Handy, but I disagree with your conclusion - I still believe it's a bug. The issue also happens if you bind the WebGrid to a plain old SQLDataSource instead of the ISDataSource.

If you read Microsoft's documentation http://msdn.microsoft.com/en-us/library/59bfya48.aspx it says "By adding filtering to a SqlDataSource control, you can change what data is made available by the SqlDataSource after a query has been run, without returning to the database."

Every other bound control (Gridviews, Dropdowns....) behave this way - ie, changing the data that is sent to the bound control. Your WebGrid does not.

Now, I had to go down this path because of all the problems that I've run into trying to get the WebGrid to Filter and Sort programatically (either by javascript or code behind).

Some of our users can't figure out how to use the FilterBar, so I wanted to add buttons to the form which would have pre-defined filters and sorts.
I started with the sample on this page http://www.intersoftpt.com/Support/WebGrid/KB/Filter-a-Column-Using-HTML-Button-in-WebGrid/ which hooks some javascript up to a button, to add and remove filtering from the WebGrid. This works, but only in very simple conditions. ie, if you click the 'add filter' button, the WebGrid does filter - great. Now, show the filterbar, manually add another filter, then click 'Remove Filter'. 'Remove Filter' does not remove the 2 filters that are now being used by the WebGrid. My application may have 3, 4 or 5 filters applied at any time, so trying to keep track of how many filters to remove does not seem easy to do. There does not seem to be a "grid.RootTable.FilteredColumns.Remove(All)" function.

And I never got sorting working at all (using javaScript). If you have a sample that shows how to add and remove sort order using javascript, it would be great. So, being a good programmer, I thought that if I changed the dataSource, the WebGrid would just show what the datasource was sending it. But your WebGrid does not behave this way.

Any other ideas?
Thanks,
Jim

WebGrid and ISDataSource Filtering issue

handy@intersoftpt.com — Wed, 07 Dec 2011 22:55:22 GMT

Hello,

Based on discussion with our developer teams, unfortunately, it is not a bug. Using FilterExpression does not mean the operation done in server. In server, ISDataSource still selects based on your SelectMethod. There is no filter expression in query at all. So, basically, filter expression process is done in client side process.
Since WebGrid has its own mechanism for filtering, filter expression from ISDataSource would be reset because it is client side operation.

Regards,
Handy

WebGrid and ISDataSource Filtering issue

handy@intersoftpt.com — Wed, 07 Dec 2011 22:26:08 GMT

Hi,

I can replicate your issue. I would try to discuss with our developer teams regarding this matter. I will let you know when it's done.

Regards,
Handy

WebGrid and ISDataSource Filtering issue

jdresser@idexcorp.com — Wed, 07 Dec 2011 20:06:34 GMT

I've found a problem where a WebGrid, which is bound to a ISDataSource, is not showing filtered data, even though the ISDatasource is filtered. I'm using the latest dlls from WebStudio 2011 R1 SP1.

Let me explain. Below is some very basic code - there is nothing on the code behind page, it's all on the aspx page. There's a webGrid, and asp:GridView, and a ISDataSource. The ISData source is connected to a database table, and it has a FilterExpression to limit the data that is returned.

Now, Both the WebGrid and the asp:GridView are bound to this ISDataSource. I expect the WebGrid to show the filtered data, but it doesn't, the WebGrid shows all of the data from the datasource, not the filtered data.

Yet, the asp:GridView, which is bound to the very same ISDataSource control, does show just the filtered data.

If both controls are bound to the same datasource, why don't they show the same data? Please explain how I can get the WebGrid to show the filtered data that the ISDataSource is providing. I do not want to use the filtering that is part of the WebGrid, I want the filtering to be done in the ISDatasource.

Thanks, Jim

      <ISWebGrid:WebGrid ID="WebGrid1" runat="server" DataMember="Summaries_WebCatFilters" DataSourceID="ISDataSource2" Height="250px" 
        UseDefaultStyle="True" >
        <RootTable DataKeyField="Pid" >
          <Columns>
            <ISWebGrid:WebGridColumn Caption="Pid" DataMember="Pid" DataType="System.Int32" Name="Pid" Width="100px">
            </ISWebGrid:WebGridColumn>
            <ISWebGrid:WebGridColumn Caption="FullPartNumber" DataMember="FullPartNumber" Name="FullPartNumber" Width="100px">
            </ISWebGrid:WebGridColumn>
          </Columns>
        </RootTable>
      </ISWebGrid:WebGrid>
      <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" CssClass="text" DataKeyNames="FullPartNumber"
        DataSourceID="ISDataSource2" Width="100%">
        <Columns>
          <asp:BoundField DataField="Pid" HeaderText="Pid" InsertVisible="False" ReadOnly="True" SortExpression="Pid" />
          <asp:BoundField DataField="FullPartNumber" HeaderText="FullPartNumber" InsertVisible="False" ReadOnly="True" SortExpression="FullPartNumber" />
        </Columns>
        <PagerStyle CssClass="pager" />
        <HeaderStyle CssClass="header" />
      </asp:GridView>
      
      <ISDataSource:ISDataSource ID="ISDataSource2" runat="server" SchemaName="WebSpecMaster.App_Code.DataSet_ISISWebStaging">
        <Tables>
          <ISDataSource:ISDataSourceTable SelectMethod="GetData" TableName="Summaries_WebCatFilters" 
            FilterExpression="FullPartNumber Like '12345'" 
            TypeName="WebSpecMaster.App_Code.DataSet_ISISWebStagingTableAdapters.Summaries_WebCatFiltersTableAdapter">
          </ISDataSource:ISDataSourceTable>
        </Tables>
      </ISDataSource:ISDataSource>