Comments on Code On Time: Server-Side Data Filters

You need to link your class to the data controller...

2010-09-23T11:53:52.135-07:00

You need to link your class to the data controller through "handler" attribute.

We suggest that you consider using view filters instead as described at http://blog.codeontime.com/2010/05/sort-and-filter.html

Tried to load the Class1 but still no filtering. W...

2010-09-06T14:11:06.327-07:00

Tried to load the Class1 but still no filtering. Where exactly is the code added to,i added it to my page codebehind but it doesnt seem to be called?

public class Class1 : IDataFilter
{

public void Filter(SortedDictionary filter)
{
int FormNo;
if (HttpContext.Current.Session["FormNo"] == null)
{
FormNo = Convert.ToInt32('8');
}
else
{
FormNo =Convert.ToInt32(HttpContext.Current.Session["FormNo"]);

}
filter.Add("FormNo", FormNo);

}
}

I have tried creating IDataFilter interface in Com...

2009-02-16T02:11:00.000-08:00

I have tried creating IDataFilter interface in Common.vb

Public Interface IDataFilter
Sub Filter(ByVal filter As SortedDictionary(Of String, Object))
End Interface

And then I created Class1 following your tutorial and also made change to the controller.xml file, also tried to pass the values using session variables. But still no filteration is available.

Is the files created using your premium subscription is different from that created using your free version?

Pravin,

You don't have to create an ins...

2009-02-13T21:37:00.000-08:00

Pravin,

You don't have to create an instance of Class1 explicitly. Simply modify dataController element to include the class name in dataFilterType attribute:

<dataController name="Orders" ... dataFilterType="Class1">

The class instance is automatically created when data is about to be returned to the client. You can communicate with the class via Session object.

For example, in your *.aspx page assign values to session variables EmployeeID and ShipVia:

Protected Sub Button1_Click(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles Button1.Click
Session("EmployeeID") = 45
Session("ShipVia") = 2
End Sub

Use session variables as in this example:

Imports System.Collections.Generic
Imports MyCompany.Data

Public Class Class1
Implements IDataFilter

Public Sub Filter(ByVal filter As SortedDictionary(Of String, Object)) _
Implements MyCompany.Data.IDataFilter.Filter
filter.Add("EmployeeID", HttpContext.Current.Session("EmployeeID"))
filter.Add("ShipVia", HttpContext.Current.Session("ShipVia"))
End Sub
End Class

Can you please show me the code where you may have...

2009-02-12T23:12:00.000-08:00

Can you please show me the code where you may have created a instance to the class "Class1" and passed filters to "EmployeeId" and "ShipVia" fields.

Server-side data filters are supported in Data Aqu...

2008-10-29T15:55:00.000-07:00

Server-side data filters are supported in Data Aquarium Framework, which is available to premium project subscribers only.

Where is the IDataFilter class located. I download...

2008-10-29T14:02:00.000-07:00

Where is the IDataFilter class located. I downloaded the latest version of the CodeGenerator and I Don't have access to the Interface.

Thanks :)

Can you provide an example of this?

In a re...

2008-10-21T20:11:00.000-07:00

Can you provide an example of this?

In a real-world scenario you will likely use HttpContext.Current.User.Identity property or HttpContext.Current.User.IsInRole method to determine the scope of data that you want to include in the result set displayed to a currently signed in user. Make sure to add System.Web namespace to the list of namespaces in your data filter to get access to HttpContext.Current property.