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.