Hi,

My radgrid using auto ops with template. The update failed due to dropdownlist selectedvalue. If a record's field is null then a update with value will yield error for cannot convert DbNull to Int32. If a record's field has value then a update do nothing but no error.

Please help.

Thanks.

extracted codes from aspx:

    <telerik:RadGrid ID="rgInst" runat="server" CellSpacing="0" GridLines="None" RenderMode="Lightweight" AllowPaging="True" PageSize="10" AllowSorting="true"
      AllowAutomaticUpdates="True" AllowAutomaticInserts="True" AllowAutomaticDeletes="true" AutoGenerateColumns="false" DataSourceID="sdsInstitution"
      OnItemCreated="rgInst_ItemCreated" OnItemInserted="rgInst_ItemInserted" OnItemUpdated="rgInst_ItemUpdated" OnItemDeleted="rgInst_ItemDeleted" OnItemCommand="rgInst_ItemCommand">
      <PagerStyle Mode="NextPrevNumericAndAdvanced" />
      <MasterTableView AutoGenerateColumns="false" DataSourceID="sdsInstitution" DataKeyNames="InstID, InstTypeId" CommandItemDisplay="Top" EditMode="EditForms">       
        <Columns>
          <telerik:GridEditCommandColumn UniqueName="EditCommandColumn" />
          <telerik:GridBoundColumn UniqueName="InstName" DataField="InstName" HeaderText="Institution" />
          <telerik:GridBoundColumn UniqueName="CampusType" DataField="InstTypeDesc" HeaderText="Campus Type" />
          <telerik:GridButtonColumn Text="Deactivate" CommandName="Delete" />
        </Columns>
  
  <EditFormSettings EditFormType="Template">
          <FormTemplate>
            <br />
                  <table class="tableW100">
                    <tr>
                      <td class="td30R">Institution name:</td>
                      <td class="td70L">
                        <asp:TextBox ID="tbInstName" runat="server" CssClass="tbW100" Text='<%# Bind("InstName") %>' />
                      </td>
                    </tr>
                    <tr>
                      <td class="td30R">School/Department:</td>
                      <td class="td70L">
                        <asp:TextBox ID="tbInstOffice" runat="server" CssClass="tbW100" TextMode="MultiLine" Text='<%# Bind("InstOffice") %>' />
                      </td>
                    </tr>
                    <tr>
                      <td class="td30R">Campus Type:</td>
                      <td class="td70L">
                        <asp:DropDownList ID="ddlInstType" CssClass="tbW100" runat="server" DataSourceID="sdsInstType" DataTextField="InstTypeDesc" DataValueField="InstTypeID" SelectedValue='<%# Bind("InstTypeID") %>'
                          AppendDataBoundItems="True">
                          <asp:ListItem Selected="True" Text="Select..." Value="" />
                        </asp:DropDownList>
                      </td>
                    </tr>
              <tr>
                <td colspan="2" class="tr4Btn">
                  <asp:Button ID="btnUpdate" CssClass="flatbtnFlexSmall" Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>' runat="server" CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>' />&nbsp;
                  <asp:Button ID="btnCancel" CssClass="flatbtnFlexSmall" Text="Cancel" runat="server" CausesValidation="False" CommandName="Cancel" />
                </td>
              </tr>
            </table>
          </FormTemplate>
        </EditFormSettings>
      </MasterTableView>
    </telerik:RadGrid>

<asp:SqlDataSource ID="sdsInstitution" runat="server" ConnectionString="<%$ ConnectionStrings:MainDB %>"
    SelectCommand="sprInstitutionGet" SelectCommandType="StoredProcedure"
    UpdateCommand="sprInstitutionUpdate" UpdateCommandType="StoredProcedure"
    InsertCommand="sprInstitutionAdd" InsertCommandType="StoredProcedure"
    <InsertParameters>
      <asp:Parameter Name="InstName" Type="String" />
      <asp:Parameter Name="InstOffice" Type="String" />
      <asp:Parameter Name="InstTypeID" Type="Int32" />
      <asp:SessionParameter Name="ModBy" SessionField="AdmNetID" Type="String" />
    </InsertParameters>
    <UpdateParameters>
      <asp:Parameter Name="InstID" Type="Int32" />
      <asp:Parameter Name="InstName" Type="String" />
      <asp:Parameter Name="InstOffice" Type="String" />
      <asp:Parameter Name="InstTypeID" Type="Int32" />
      <asp:SessionParameter Name="ModBy" SessionField="AdmNetID" Type="String" />
    </UpdateParameters>
</asp:SqlDataSource>

<asp:SqlDataSource ID="sdsInstType" runat="server" ConnectionString="<%$ ConnectionStrings:MainDB %>" SelectCommand="sprInstitutionTypeGet" SelectCommandType="StoredProcedure" />

Hi,

    I need to disable edit mode for a specific column in a gantt control regarding to some criteria. Could you help me? 

regards

I have a scenario where I am binding Radgrid at server side in Page Load with default filter criteria and additionally there are some tile buttons for the user to filter the Radgrid list.

Now I have filter enabled in the Radgrid, so whenever the user uses the filter in the Radgrid, it triggers the pageload databinding of the radgrid and uses the default criteria.

Is there a way for the Radgrid not to use the Pageload binding and still apply the filter with the list it has.

Note:I am using the server side binding

Hi, I'm trying to make my Checkbox clickable if that's a word.. I am having trouble because when I try to change it into a <telerik:GridTemplateColumn> with a the ItemTemplate stuff data does not get fetched from the server. To clear it up when I change it to a TemplateColumn the data from the server does not transfer and the checkboxes ARE clickable but checks do not appear where they should be. What I want is the checkboxes to appear as "clickable" and data appears where it should be, and also when a checkbox is checked the data will go to the SQL server. Sorry, if I'm asking for too much.... I'm still learning.:)

I know there's a bunch of junk in my <telerik:RadGrid /> I was trying to solve my issue and couldn't, let me know if you need more info, I'll send whatever I can.

Hello All,  

    I have simple radgrid with to/from date filter option. But when I change the dates in the filter, its not updating the grid. Following is my simple code. I have tried everything in the tutorial, but no luck. Any help is appreciated. 

<telerik:RadGrid RenderMode="Lightweight" ID="rgScreening" runat="server" Width="100%" Enabled ="true" 
        FilterItemStyle-BackColor="#e6e6e6" FilterItemStyle-BorderStyle="Solid" OnPreRender="rgScreening_PreRender"
        OnItemCommand="rgScreening_ItemCommand">
        <HeaderStyle CssClass="gridViewHeader" />
        <PagerStyle Mode="NumericPages" CssClass="gridViewPager" />
        <ItemStyle CssClass="gridViewRow" />
        <AlternatingItemStyle CssClass="gridViewAltRow" />
        <SelectedItemStyle CssClass="gridViewSelected" />
        <MasterTableView AllowSorting="true" PageSize="10" AllowPaging="True" Width="100%" AutoGenerateColumns="false" CommandItemDisplay="None" 
            AllowFilteringByColumn="true">
        <CommandItemSettings ShowAddNewRecordButton="false" ShowRefreshButton="false" />            
        <Columns>
            <telerik:GridBoundColumn UniqueName="ProviderOrOwner" DataField="ProviderOrOwner" HeaderText="Provider/Owner">
                <FilterTemplate>
                    <telerik:RadComboBox RenderMode="Lightweight" runat="server" ID="rcbProviderOrOwner" 
                        SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("ProviderOrOwner").CurrentFilterValue %>' 
                        OnClientSelectedIndexChanged="ProviderOrOwnerSelectedIndexChanged" Width="80px">
                        <Items>
                            <telerik:RadComboBoxItem runat="server" Text="All"/>
                            <telerik:RadComboBoxItem runat="server" Text="Provider" Value="Provider" />
                            <telerik:RadComboBoxItem runat="server" Text="Owner" Value="Owner" />
                        </Items>
                    </telerik:RadComboBox>
                    <telerik:RadScriptBlock ID="RadScriptBlock2" runat="server">
                        <script type="text/javascript">
                            function ProviderOrOwnerSelectedIndexChanged(sender, args) {
                                var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
                                tableView.filter("ProviderOrOwner", args.get_item().get_value(), "EqualTo");
                            }
                        </script>
                    </telerik:RadScriptBlock>
                </FilterTemplate>
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn UniqueName="ScreeningDate" DataField="ScreeningDate" HeaderText="Screening Date" DataFormatString="{0:D}" >
            <FilterTemplate>
                <span style="width:50px; font-weight:bold; text-align:right">From</span>
                <telerik:RadDatePicker RenderMode="Lightweight" ID="FromScreeningDatePicker" runat="server" Width="120px" ClientEvents-OnDateSelected="FromDateSelected"
                MinDate='<%# Convert.ToDateTime("01/01/1900")%>' MaxDate='<%# Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy"))%>'
                DbSelectedDate='<%# startDate %>' FocusedDate="01/01/2016"
                 DateInput-ForeColor="Black" Calendar-CalendarTableStyle-BackColor="#cccccc" Calendar-BackColor="White" Calendar-HeaderStyle-BackColor="White" 
                Calendar-TitleStyle-BackColor="White" DateInput-BorderColor="Black"/> &nbsp;            
                <span style="width:50px; font-weight:bold; text-align:right">To</span>
                <telerik:RadDatePicker RenderMode="Lightweight" ID="ToScreeningDatePicker" runat="server"  Width="120px" ClientEvents-OnDateSelected="ToDateSelected"
                MinDate='<%# Convert.ToDateTime("01/01/1900")%>' MaxDate='<%# Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy"))%>'
                DbSelectedDate='<%# endDate %>' FocusedDate='<%# Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy"))%>'
                DateInput-ForeColor="Black" Calendar-CalendarTableStyle-BackColor="#cccccc" Calendar-BackColor="White" Calendar-HeaderStyle-BackColor="White" 
                Calendar-TitleStyle-BackColor="White" DateInput-BorderColor="Black"></telerik:RadDatePicker>
                <telerik:RadScriptBlock ID="RadScriptBlock1" runat="server">
                    <script type="text/javascript">
                        function FromDateSelected(sender, args) {
                            var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
                            var ToPicker = $find('<%# ((GridItem)Container).FindControl("ToScreeningDatePicker").ClientID %>');
                            var fromDate = FormatSelectedDate(sender);
                            var toDate = FormatSelectedDate(ToPicker);
                            tableView.filter("ScreeningDate", fromDate + " " + toDate, "Between");
                        }
                        function ToDateSelected(sender, args) {
                        var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
                        var FromPicker = $find('<%# ((GridItem)Container).FindControl("FromScreeningDatePicker").ClientID %>');
                        var fromDate = FormatSelectedDate(FromPicker);
                        var toDate = FormatSelectedDate(sender);
                        var dtfilter = fromDate + "  " + toDate
                        tableView.filter("ScreeningDate", tfilter, "Between");
                    }
                    function FormatSelectedDate(picker) {
                        var date = picker.get_selectedDate();
                        var dateInput = picker.get_dateInput();
                        var formattedDate = dateInput.get_dateFormatInfo().FormatDate(date, "MM/dd/yyyy hh:mm:ss tt");
                        return formattedDate;
                    }
                    </script>
                </telerik:RadScriptBlock>
            </FilterTemplate>

        </telerik:GridBoundColumn>

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