I am trying to set a filter to my datagrid. I have a dropdown list with letters A-Z and I want the user to select a letter and just show all records beginning with that letter.

This is the code I am using:

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

SqlConnection1.ConnectionString = ConfigurationSettings.AppSettings("PTO_DSN")

If Not Page.IsPostBack Then
BindGrid()
End If

End Sub

Sub BindGrid()

DataSet1 = New DataSet
sql_mem_list.Fill(DataSet1)
DataView1 = DataSet1.Tables(0).DefaultView
DataSet1.Tables(0).DefaultView.Sort = "orgname"

Dim StrletterFilter As String
StrletterFilter = ddFilter.SelectedItem.Value
If StrletterFilter = "All" Then
DataSet1.Tables(0).DefaultView.RowFilter = String.Empty
Else
DataSet1.Tables(0).DefaultView.RowFilter = "orgname LIKE '" & StrletterFilter & "%'"
End If

DataGrid1.DataSource = DataView1
DataGrid1.DataBind()

End Sub

Private Sub DataGrid1_PageIndexChanged(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEventArgs) Handles DataGrid1.PageIndexChanged

DataGrid1.CurrentPageIndex = e.NewPageIndex

BindGrid()

End Sub

But it only ever brings in member companies beginning with the letter A.

Any help would be greatly appreciated.

Hello!

Hope this helps:

DataGrid1.DataSource = DataSet1.Tables(0).DefaultView

And this way you will not need de DataView1

Greetings,

Agus

I've tried that but it still gives the same problem.