Hello,
Eyup, I have fit your solution in my project, but for some reason the OnDataBinding event is being triggered infinite times and the same query is being sent to the database. Am I missing something? Here's my code.
APSX
<
telerik:GridBoundColumn
UniqueName
=
"GradeCode"
DataField
=
"GradeCode"
HeaderText
=
"Grade Code"
>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"RadComboBox2"
runat
=
"server"
AppendDataBoundItems
=
"true"
OnDataBinding
=
"RadComboBox2_DataBinding"
OnSelectedIndexChanged
=
"RadComboBox2_SelectedIndexChanged"
>
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"Select"
/>
</
Items
>
</
telerik:RadComboBox
>
</
FilterTemplate
>
</
telerik:GridBoundColumn
>
code behind
private
void
DropBoxBindData(RadComboBox dropDownList)
{
using
(var myContext =
new
TelerikWebApp1.App_Code.UkConverterEntities())
{
var gradeCode = myContext.Northgates.Select(m => m.GradeCode).Distinct().ToList();
dropDownList.DataSource = gradeCode;
dropDownList.DataBind();
}
}
protected
void
RadComboBox2_DataBinding(
object
sender, EventArgs e)
{
RadComboBox combo = sender
as
RadComboBox;
combo.DataTextField =
"GradeCode"
;
combo.DataValueField =
"GradeCode"
;
DropBoxBindData(combo);
}