I have a radgrid with Allow automaticupdates but when I try it it does update the database below is my asp.net code

<%@ Page Title="" Language="VB" MasterPageFile="~/Header.master" AutoEventWireup="false" CodeFile="InvoiceSchedule.aspx.vb" Inherits="StepIII_InvoiceSchedule" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>

<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="asp" %>


  
   <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
        <Scripts>
            <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js"></asp:ScriptReference>
            <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js"></asp:ScriptReference>
            <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js"></asp:ScriptReference>
        </Scripts>
      
    </telerik:RadScriptManager>

<div class="Invoice">

       <%-- Created a gridview that has templates --%>
         
          <asp:SqlDataSource ID="sqlMonth" runat="server" ConnectionString="<%$ ConnectionStrings:COSIGrantsDB %>" SelectCommand="SELECT * FROM [lkp_Month]"></asp:SqlDataSource>
          <asp:SqlDataSource ID="sqlYear" runat="server" ConnectionString="<%$ ConnectionStrings:COSIGrantsDB %>" SelectCommand="SELECT * FROM [lkp_Year]"></asp:SqlDataSource>
          <asp:SqlDataSource ID="sqlInvoiceSource" runat="server" ConnectionString="<%$ ConnectionStrings:COSIGrantsDB %>" SelectCommand="SELECT SourceID as SID, Source AS invoicesource FROM lkp_InvoiceSource"></asp:SqlDataSource>
          <asp:SqlDataSource runat="server" ID="sqlInvoice" ConnectionString='<%$ ConnectionStrings:COSIGrantsDB %>' SelectCommand="SELECT InvoiceSchedule_Test.Amount, lkp_Month.Month, InvoiceSchedule_Test.MonthId, InvoiceSchedule_Test.YearId, InvoiceSchedule_Test.SourceId, lkp_Year.Year, lkp_InvoiceSource.Source, InvoiceSchedule_Test.ApplicationID, InvoiceSchedule_Test.InvoiceScheduleId FROM InvoiceSchedule_Test LEFT OUTER JOIN lkp_Month ON InvoiceSchedule_Test.MonthId = lkp_Month.MonthID LEFT OUTER JOIN lkp_Year ON InvoiceSchedule_Test.YearId = lkp_Year.YearID LEFT OUTER JOIN lkp_InvoiceSource ON InvoiceSchedule_Test.SourceId = lkp_InvoiceSource.SourceID WHERE (InvoiceSchedule_Test.ApplicationID = @AppID)" InsertCommand="INSERT INTO InvoiceSchedule_Test(MonthId, YearId, Amount, SourceId, ApplicationID) VALUES (@monthid, @yearid, @amount, @sourceid, @appid)" DeleteCommand="Delete from InvoiceSchedule_test where invoicescheduleid=@invoiceid" UpdateCommand="UPDATE InvoiceSchedule_Test SET MonthId = @monthid, YearId = @yearid, Amount = @amount, SourceId = @sourceid, ApplicationID = @appid WHERE (InvoiceScheduleId = @invoiceschedid)">

              <DeleteParameters>
                  <asp:Parameter Name="invoiceid"></asp:Parameter>
              </DeleteParameters>
              <InsertParameters>
                  <asp:Parameter Name="monthid"></asp:Parameter>
                  <asp:Parameter Name="yearid"></asp:Parameter>
                  <asp:Parameter Name="amount"></asp:Parameter>
                  <asp:Parameter Name="sourceid"></asp:Parameter>
                  <asp:SessionParameter SessionField="appid" Name="AppID" Type="Int32"></asp:SessionParameter>
              </InsertParameters>
              <SelectParameters>
                  <asp:SessionParameter SessionField="appid" Name="AppID" Type="Int32"></asp:SessionParameter>
              </SelectParameters>
              <UpdateParameters>
                  <asp:Parameter Name="monthid"></asp:Parameter>
                  <asp:Parameter Name="yearid"></asp:Parameter>
                  <asp:Parameter Name="amount"></asp:Parameter>
                  <asp:Parameter Name="sourceid"></asp:Parameter>
                  <asp:SessionParameter SessionField="appid" Name="AppID" Type="Int32"></asp:SessionParameter>
           <asp:Parameter Name="invoiceschedid" />
                     </UpdateParameters>


          
          </asp:SqlDataSource>
          <telerik:RadGrid ID="rg" runat="server" AutoGenerateEditColumn="True" DataSourceID="sqlInvoice" AutoGenerateDeleteColumn="True" AllowAutomaticUpdates="True" AllowAutomaticDeletes="True" AllowAutomaticInserts="True">

<GroupingSettings CollapseAllTooltip="Collapse all groups"></GroupingSettings>

              <MasterTableView DataKeyNames="InvoiceScheduleId" DataSourceID="sqlInvoice" AutoGenerateColumns="False" AllowAutomaticUpdates="true" AllowAutomaticDeletes="true" AllowAutomaticInserts="true" CommandItemDisplay="top">
                  <Columns>
                      <telerik:GridBoundColumn DataField="Amount" HeaderText="Amount" SortExpression="Amount" UniqueName="Amount" DataType="System.Decimal" FilterControlAltText="Filter Amount column"></telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="Month" HeaderText="Month" SortExpression="Month" UniqueName="Month" FilterControlAltText="Filter Month column"></telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="MonthId" HeaderText="MonthId" SortExpression="MonthId" UniqueName="MonthId" DataType="System.Int32" FilterControlAltText="Filter MonthId column"></telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="YearId" HeaderText="YearId" SortExpression="YearId" UniqueName="YearId" FilterControlAltText="Filter YearId column" DataType="System.Int32"></telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="SourceId" HeaderText="SourceId" SortExpression="SourceId" UniqueName="SourceId" FilterControlAltText="Filter SourceId column"></telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="Year" HeaderText="Year" SortExpression="Year" UniqueName="Year" DataType="System.Int32" FilterControlAltText="Filter Year column"></telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="Source" FilterControlAltText="Filter Source column" HeaderText="Source" SortExpression="Source" UniqueName="Source">
                      </telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="ApplicationID" DataType="System.Int32" FilterControlAltText="Filter ApplicationID column" HeaderText="ApplicationID" SortExpression="ApplicationID" UniqueName="ApplicationID">
                      </telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="InvoiceScheduleId" DataType="System.Int32" FilterControlAltText="Filter InvoiceScheduleId column" HeaderText="InvoiceScheduleId" ReadOnly="True" SortExpression="InvoiceScheduleId" UniqueName="InvoiceScheduleId">
                      </telerik:GridBoundColumn>
                  </Columns>
              </MasterTableView>
          </telerik:radgrid>
       <%--   <telerik:RadGrid ID="rg" runat="server" AutoGenerateDeleteColumn="True" allowautomaticdeletes="true" AutoGenerateEditColumn="True" DataSourceID="sqlInvoice" AllowAutomaticInserts="True" onUpdateCOmmand="rg_Update" AutoGenerateColumns="False" CellSpacing="-1" GridLines="Both" onDeleteCommand="rg_DeleteCommand"  >



            <MasterTableView DataKeyNames="InvoiceScheduleId" DataSourceID="sqlInvoice" commanditemdisplay="top" >
                   <Columns>
                         <telerik:GridBoundColumn HeaderText="invoiceid" datafield="invoicescheduleid"></telerik:GridBoundColumn>
                
                         <telerik:GridTemplateColumn DataField="source" FilterControlAltText="Filter Invoicesource column" HeaderText="source" UniqueName="Invoicesource">
                             <EditItemTemplate>
                                 <asp:DropDownList ID="sourceDropDownList" runat="server" DataSourceID="sqlInvoiceSource" DataTextField="invoicesource" DataValueField="sid">
                                 </asp:DropDownList>
                             </EditItemTemplate>
                             <ItemTemplate>
                                 <asp:Label ID="sourceLabel" runat="server" Text='<%# Eval("source") %>'></asp:Label>
                             </ItemTemplate>
                         </telerik:GridTemplateColumn>
          
                
                       <telerik:GridDropDownColumn DataField="monthid"   HeaderText="Month" uniquename="monthid" ListTextField="Month" ListValueField="monthid" datasourceid="sqlMonth"></telerik:GridDropDownColumn>
                       <telerik:griddropdowncolumn uniqueName="yearid" ListTextField="year" ListValueField="yearid" DataSourceID="sqlYear" HeaderText="Year" DataField="yearid"></telerik:griddropdowncolumn>
                       <telerik:gridboundcolumn UniqueName="amount" HeaderText="amount" Dataformatstring="{0:C}" DataField="amount"></telerik:gridboundcolumn>
                         
                     
            
                         
                     
                    
               
                   </Columns>
               </MasterTableView>
           </telerik:RadGrid>
       --%>
          
             </div>

Can anyone tell me what I am doing wrong?

Thanks

Robin 

Hi

I have Radgrid with two checkboxes and details table with checkbox in one column and repeater and checkbox in it in another column. When all items in details table is checked then radgrid checkbox should also be checked. similarly if repeater items are checked then radgrid checkbox should be checked. Please suggest how can this be acheived.

<radgrid>

<mastertableview>

<Columns>

<Gridtemplatecolumn>

<checkboxleft>

</Gridtemplatecolumn>

<Gridtemplatecolumn>
<checkboxright>
</Gridtemplatecolumn>

<detailstable>

<gridtableview>

<columns>

<<Gridtemplatecolumn>
<itemcheckboxleft>
</Gridtemplatecolumn>

<<Gridtemplatecolumn>

<repeater>
<itemcheckboxleft>

</repeater>
</Gridtemplatecolumn>

</columns>

</detailstable>

</columns>

</radgrid>

Hi,

I have a "RadWizard" with two "RadWizardSteps" and two different "ValidationGroups".
When I click the first button (BtnArrayAdd), the validation for the "TxtArrayName" control works correct.
When I click the second button (BtnAdd), the validation checks only the "TxtAttributeName" control but not the "CbAttributeType" control.

When I remove the first step, the validation for both controls (TxtAttributeName & CbAttributeType) works correct.

What could be the problem?

Thx,
Dominik

Dear Team,

I am working on some charts where some of them have more than 3 or 4 y-axis. The requirement is to set 2 y-axis on left side and remaining on right side.

Basically, we are trying to enable the user to customize their own chart where they can set orientation for each y-axis and save the option in back-end. I have tried with axis crossing points but it is pushing all additional y-axis to the right side. 

Any example / guidance is appreciated. 

I have a grid that is in edit mode an update delete command in grid.

I have some textboxes (for name, surname etc) and and a radgrid on my web page.(for products for example). all radgrid's rows are in "inplace" edit mode

I want to use the 'Add new Record' on the RadGrid and then with an external button want to save it to database.

Used the link as reference : https://www.telerik.com/forums/update-radgrid-with-external-button-(all-rows-in-edit-mode)

hi,

I'm trying to figure out how to add a clickable hyperlink to a cell, currently I receive the contents from a SQL backend, check if the value contains a link and add it as a cell.Link, it currently shows them as links but they are not clickable, what pony trick am i missing? thanks for you advise. ps: this is in C#

kind regards, iwan

I have a Grid where I select a row.  When I select a row I want to capture the email address that's displayed in the Grid.  I typically use a SqlDataSource as the data source for my Grids and don't have any trouble getting the value from a cell on a selected row, but this time I had to use a DataTable.  Please help me modify my code so that I may capture the email address from the selected row on the Grid.

Here is the Grid markup:

Here is the code behind for the SelectedIndexChanged event:

Here is the code from the data table:

I am having a hard time getting the Legend label values to equal the pie series NameField values.

<telerik:RadHtmlChart ID="rhcDiscountReasons" runat="server" DataSourceID="sqlDRRAlt" ChartTitle-Text="Discount Reasons">
<ChartTitle Text="Discount Reasons">
<Appearance Visible="True">
</Appearance>
</ChartTitle>
<Legend>
<Appearance Visible="True" BackgroundColor="WindowFrame" Align="Center" Position="Bottom" Orientation="Horizontal">
    <TextStyle Color="White" FontSize="18" />
</Appearance>
<Item Visual="legendItemVisual" />
</Legend>
  <PlotArea>
                <Series>
                    <telerik:PieSeries DataFieldY="dtypecount" Name="Discount Reasons" VisibleInLegend="true" NameField="dtype">
                        <LabelsAppearance DataField="dtype">
                        </LabelsAppearance>
                    </telerik:PieSeries>
                </Series>
 </PlotArea>
</telerik:RadHtmlChart>

If I use the below code, It fills all the legend labels with "Discount Reasons", I want them to have the NameField values.  I have tried everything I could think of to access those values but cannot.  If I replace e.series.name with e.series.categoryField the legend lables all say "dtype", this is close but I want the dtype value.

var label = new drawing.Text(e.series.name, [0, 0], {
        fill: {
            color: legendLabelsColor
        }
    })

Can someone point me in the right direction?