This project is read-only.

drop doiwn

Jan 31, 2011 at 1:15 AM

what i am doing wrong that drop down not populated

<mdo:asp xmlns:asp="asp" xmlns:telerik="telerik">
      <asp:SqlDataSource
          id="dsflights"
          runat="server"
          EnableCaching="False"
          ConnectionString="blabla"
          SelectCommand="SELECT * FROM [DB_14643_ngc].[dbo].[vw_flights] where updateId={$UserName}"
              />
               <asp:SqlDataSource
          id="dsTypes"
          runat="server"
          EnableCaching="true"
          ConnectionString="bbla"
          SelectCommand="SELECT ID,type FROM [DB_14643_ngc].[dbo].[T_FlightType]"
              />
      <telerik:RadGrid
          DataSourceID="dsflights"
          DataKeyNames="ID"

          AllowPaging="True"
          PageSize="10"

          AutoGenerateColumns="False"

          AllowAutomaticDeletes="True"
          AllowAutomaticInserts="True"
          AllowAutomaticUpdates="True"

          Skin="Office2007"
          runat="server">

        <MasterTableView EditMode="EditForms" CommandItemDisplay="Bottom"
                         DataSourceID="dsflights" DataKeyNames="ID">
         <Columns>
        
        
             <telerik:GridDateTimeColumn
            FilterControlWidth="120px"
            DataField="flightDate"
            HeaderText="flightDate"
            SortExpression="flightDate"
            UniqueName="flightDate" 
            HtmlEncode="false"
            DataFormatString="{{0:D}}"
            PickerType="DatePicker"   
            DataType="System.DateTime" >
                    
                   </telerik:GridDateTimeColumn>
  
               <telerik:GridBoundColumn
              DataField="glider"
              DataType="System.String"
              HeaderText="glider"
              UniqueName="glider" />

              <telerik:GridBoundColumn
              DataField="pilot1"
              DataType="System.String"
              HeaderText="pilot1"
              UniqueName="pilot1" />

       <telerik:GridBoundColumn
              DataField="pilot2"
              DataType="System.String"
              HeaderText="pilot2"
              UniqueName="pilot2" />
             
             <telerik:GridDateTimeColumn
            FilterControlWidth="120px"
            DataField="takeOff"
            HeaderText="takeOff"
            SortExpression="takeOff"
            UniqueName="takeOff" 
               DataFormatString="{{0:t}}"
            PickerType="TimePicker"   
            DataType="System.DateTime" >
                    
                   </telerik:GridDateTimeColumn>
                  
                       <telerik:GridDateTimeColumn
            FilterControlWidth="120px"
            DataField="landing"
            HeaderText="landing"
            SortExpression="landing"
            UniqueName="landing" 
               DataFormatString="{{0:t}}"
            PickerType="TimePicker"   
            DataType="System.DateTime" >
                    
                   </telerik:GridDateTimeColumn>
                     <telerik:GridBoundColumn
              DataField="taw"
              DataType="System.String"
              HeaderText="taw"
              UniqueName="taw" />
             
              <telerik:GridDropDownColumn UniqueName="ID" ListDataMember="dsTypes"
SortExpression="ID" ListTextField="ID"
ListValueField ="ID" HeaderText="type" DataField="gridType" />

              <telerik:GridBoundColumn
              DataField="remarks"
              DataType="System.String"
              HeaderText="remarks"
              UniqueName="remarks" />
       <telerik:GridBoundColumn
              DataField="updatedBy"
              DataType="System.String"
              HeaderText="updatedBy"
              UniqueName="updatedBy" />
    
         
               <telerik:GridButtonColumn
              ConfirmText="Delete this glider?" ConfirmDialogType="RadWindow"
              ConfirmTitle="Delete" ButtonType="ImageButton"
              CommandName="Delete" Text="Delete"
              UniqueName="DeleteColumn" />
       <telerik:GridEditCommandColumn
             ButtonType="ImageButton"
             UniqueName="EditCommandColumn"/>


         </Columns>
        </MasterTableView>
      </telerik:RadGrid>
</mdo:asp>














Coordinator
Jan 31, 2011 at 7:34 AM

I'm not sure but it seems you should use 

       DataSourceID="dsTypes"

instead of

       ListDataMember="dsTypes"

as ListDataMember is used in .NET 1.1 and reference dataset.

But what I'd recommend is to use VS to create a user control that will provide all functions and use XsltDb to put it on the DotNetNuke page, assign DNN-specific properties (as UserID) and maybe get results back from grid and use it somehow. In case of ASP.NET XsltDb is more integration platform than development environment.