I'm using a RadGrid GridDropDownColumn which is connected to a SqlDataSource:
This is my datasource:
When I click on 'Add a Record' button, the dropdown does not populate with the records from the datasource, but if I click on the Refresh button while it is in Insert mode (showing textboxes and the empty dropdown), then the dropdown populates.
I've wasted a lot of time trying to make this work, so that the dropdown populates when the user clicks on the 'Add a Record' button, but I've not succeeded.
Can you please help me out with this?
I would really appreciate it.
<
telerik:GridDropDownColumn
DataField
=
"Status_ID"
DataSourceID
=
"SqlDataSource_WTGTasksStatus"
HeaderText
=
"Status"
ListTextField
=
"Status_Text"
ListValueField
=
"Status_ID"
UniqueName
=
"Status_ID"
ColumnEditorID
=
"StatusDropdownEditor"
>
Here is my Column Editor:
<
telerik:GridDropDownListColumnEditor
ID
=
"StatusDropdownEditor"
DropDownStyle-Width
=
"75px"
runat
=
"server"
/>
This is my datasource:
<
asp:SqlDataSource
ID
=
"SqlDataSource_WTGTasksStatus"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:ParkAnalyticsConnectionString %>"
SelectCommand="SELECT [Status_ID], [Status_Text] FROM [WTGTasksStatus]">
</
asp:SqlDataSource
>
When I click on 'Add a Record' button, the dropdown does not populate with the records from the datasource, but if I click on the Refresh button while it is in Insert mode (showing textboxes and the empty dropdown), then the dropdown populates.
I've wasted a lot of time trying to make this work, so that the dropdown populates when the user clicks on the 'Add a Record' button, but I've not succeeded.
Can you please help me out with this?
I would really appreciate it.