Hi hi :)
I have a column in a grid:
using this data source:
I want to be able to filter the grid by Name, but it filters by ID for some reason. Here's what I mean:
if I filter by name this happens:
http://i.imgur.com/F3lJxnN.png
if I filter by Gretchen's ID, this happens:
http://i.imgur.com/qkz96vj.png
So it is filtering by the wrong field but I think I have the settings correct, yes?
I have a column in a grid:
<
telerik:GridDropDownColumn
DataField
=
"CustomerID"
DataType
=
"System.String"
DataSourceID
=
"SqlDataSource4"
FilterControlAltText
=
"Filter CustomerName column"
HeaderText
=
"Customer Name"
ListTextField
=
"Name"
ListValueField
=
"ID"
SortExpression
=
"Name"
UniqueName
=
"CustomerName"
>
<
ColumnValidationSettings
>
using this data source:
<
asp:SqlDataSource
ID
=
"SqlDataSource4"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:NameOfString %>" SelectCommand="SELECT [Name], [ID] FROM [Customer] ORDER BY [Name]"></
asp:SqlDataSource
>
I want to be able to filter the grid by Name, but it filters by ID for some reason. Here's what I mean:
if I filter by name this happens:
http://i.imgur.com/F3lJxnN.png
if I filter by Gretchen's ID, this happens:
http://i.imgur.com/qkz96vj.png
So it is filtering by the wrong field but I think I have the settings correct, yes?