This is a migrated thread and some comments may be shown as answers.

Filtering not working

15 Answers 138 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Web Services asked on 27 Jan 2012, 09:34 PM

I'm binding a rad grid with a data table. Whenever I use the filter, I get no results back when I know I should be getting some. Any ideas why? The sorting works fine. Here's my code.

<telerik:RadGrid ID="RadGrid1" runat="server" GridLines="None" AllowPaging="True" AllowFilteringByColumn="true"

AllowSorting="True" AutoGenerateColumns="false" PageSize="50" Height="410px" Skin="Hay">

<MasterTableView DataKeyNames="customerId" AutoGenerateColumns="false">

<Columns>

<telerik:GridBoundColumn DataField="Edit" HeaderText="<span style='visibility: hidden;'>a</span>" SortExpression="Edit"

UniqueName="Edit" HeaderStyle-Width="40px" AllowFiltering="false" AllowSorting="false">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="name" HeaderText="Name" SortExpression="name"

UniqueName="name">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="address" HeaderText="Address" SortExpression="address"

UniqueName="address">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="city" HeaderText="City" SortExpression="city"

UniqueName="city">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="state" HeaderText="State" SortExpression="state"

UniqueName="state">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="zip" HeaderText="Zip" SortExpression="zip"

UniqueName="zip">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="phone" HeaderText="Phone" SortExpression="phone"

UniqueName="phone">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="fax" HeaderText="Fax" SortExpression="fax"

UniqueName="fax">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="email" HeaderText="Email" SortExpression="email"

UniqueName="email">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="additional" HeaderText="Additional Info" SortExpression="additional"

UniqueName="additional" ItemStyle-Width="200">

</telerik:GridBoundColumn>

</Columns>

</MasterTableView>

<HeaderStyle Width="120px" />

<ClientSettings>

<Scrolling AllowScroll="True" UseStaticHeaders="True" SaveScrollPosition="True">

</Scrolling>

</ClientSettings>

</telerik:RadGrid>

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

If Not (Page.IsPostBack) Then

RadGrid1.DataSource = myFunctions.customerListTable()

RadGrid1.DataBind()

End If

End Sub

Protected Sub RadGrid1_NeedDataSource(ByVal source As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles RadGrid1.NeedDataSource

RadGrid1.DataSource = myFunctions.customerListTable()

End Sub

'this function creates a data table for the customer list

Public Shared Function customerListTable()

Dim sql = "SELECT customerId, name, address, city, state, zip, phone, email, fax, additional FROM Customers" & _

" WHERE deleted = 'false' ORDER BY name"

Dim conn As String = System.Configuration.ConfigurationManager.ConnectionStrings("connection").ToString

Using myConn As New SqlConnection(conn)

'create the table

Dim myTable As New DataTable

myTable.Columns.Add("customerId")

myTable.Columns.Add("edit")

myTable.Columns.Add("name")

myTable.Columns.Add("address")

myTable.Columns.Add("city")

myTable.Columns.Add("state")

myTable.Columns.Add("zip")

myTable.Columns.Add("phone")

myTable.Columns.Add("email")

myTable.Columns.Add("fax")

myTable.Columns.Add("additional")

myConn.Open()

Dim cmd As New SqlCommand(sql, myConn)

Dim reader = cmd.ExecuteReader

While reader.Read()

myTable.Rows.Add(reader("customerId"), "<a href=""../Customers/EditCustomer.aspx?id" & reader("customerId") & """>Edit</a>", _

reader("name"), reader("address"), reader("city"), reader("state"), reader("zip"), _

reader("phone"), reader("email"), reader("fax"), reader("additional"))

End While 'while reader.read

myConn.Close()

Return myTable

End Using 'using myConn

End Function 'customerListTable

15 Answers, 1 is accepted

answered on 02 Feb 2012, 07:10 PM

This is what my code looks like now, the filter still does not work. I looked at that documentation, but I don't see what I'm doing wrong. I'm not filling it with an SQL adapter and is the only real difference, I could see from your example. However, I change my code to use the sqldataadapter and fill a table but I still have the same problem. Any ideas? I can provide a link to download my project if you like.

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

If Not (Page.IsPostBack) Then

RadGrid1.DataSource = myFunctions.customerListTable()

End If

End Sub

Protected Sub RadGrid1_NeedDataSource(ByVal source As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles RadGrid1.NeedDataSource

RadGrid1.DataSource = myFunctions.customerListTable()

End Sub

answered on 07 Feb 2012, 03:37 PM

This is my code, it's almost exactly what the example shows. It's still not working.

Imports System.Web.UI

Imports System.Data

Imports System.Data.Sql

Imports System.Data.SqlClient

Imports Telerik.Web.UI

Partial Class internal_CustomerList

Inherits System.Web.UI.Page

Dim conn As String = System.Configuration.ConfigurationManager.ConnectionStrings("connection").ToString

Protected Sub RadGrid1_NeedDataSource(ByVal source As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles RadGrid1.NeedDataSource

Dim sql = "SELECT * FROM CustomerList"

Dim myconn As New SqlConnection(conn)

Dim adapter As New SqlDataAdapter(sql, myconn)

Dim myTable As New DataTable

myconn.Open()

adapter.Fill(myTable)

myconn.Close()

RadGrid1.DataSource = myTable

End Sub

End Class