Telerik Forums
UI for ASP.NET AJAX Forum
1 answer
121 views
Hi,

I have a radgrid with that has a edittemplate with a cascading dropdown list. first dropdown allow to select project type then 2nd dropdown will bind the datasource accordingly. I have to click "Insert" twice to fire the insercommand.

                <telerik:RadGrid ID="rdGEDetails" runat="server" AllowFilteringByColumn="True" AllowPaging="True" AllowSorting="True" GridLines="None"
                    Height="383px" OnDeleteCommand="rdGEDetails_DeleteCommand" OnInsertCommand="rdGEDetails_InsertCommand"
                    OnItemDataBound="rdGEDetails_ItemDataBound" OnNeedDataSource="rdGEDetails_NeedDataSource" onUpdateCommand="rdGEDetails_UpdateCommand" Skin="Web20"
                    Width="642px" OnItemCreated="rdGEDetails_ItemCreated">
                    <ValidationSettings ValidationGroup="FormValidation" />
                    <MasterTableView AutoGenerateColumns="False" GridLines="Both" CommandItemDisplay="Top" CurrentResetPageIndexAction="SetPageIndexToLast"
                        DataKeyNames="GeneralExpenseDetailID" EditMode="PopUp" InsertItemPageIndexAction="ShowItemOnFirstPage" >
                        <Columns>
                            <telerik:GridEditCommandColumn>
                            </telerik:GridEditCommandColumn>
                            <telerik:GridButtonColumn CommandName="Delete" ConfirmText="Do you wish to delete this record?"
                                Text="Delete" UniqueName="column1">
                            </telerik:GridButtonColumn>
                            <telerik:GridBoundColumn DataField="GeneralExpenseDetailID" DataType="System.Guid" HeaderText="GeneralExpenseDetailID"
                                ReadOnly="True" SortExpression="GeneralExpenseDetailID" UniqueName="GeneralExpenseDetailID" Visible="False">
                            </telerik:GridBoundColumn>
                            <telerik:GridTemplateColumn DataField="GeneralDate" DataType="System.DateTime" HeaderText="Doc. Date" SortExpression="GeneralDate"
                                UniqueName="GeneralDate">
                                <EditItemTemplate>
                              <telerik:RadDatePicker ID="radDocdate"  MinDate="2006/1/1" runat="server" DbSelectedDate='<%# Bind("GeneralDate") %>'>
                                          <DateInput DateFormat="dd/MM/yyyy"></DateInput>
                            </telerik:RadDatePicker>                                   
                                    <asp:RequiredFieldValidator ID="rfvDocdate" runat="server" ControlToValidate="radDocdate"
                                        ErrorMessage="*" ValidationGroup="FormValidation"></asp:RequiredFieldValidator>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lblDocdate" runat="server" Text='<%# Eval("GeneralDate", "{0:dd/MM/yyyy}") %>'></asp:Label>
                                </ItemTemplate>
                            </telerik:GridTemplateColumn>
                            <telerik:GridTemplateColumn DataField="DocNo" HeaderText="Doc. No" SortExpression="DocNo"
                                UniqueName="DocNo">
                                <EditItemTemplate>
                                    <asp:TextBox ID="txtDocno" runat="server" MaxLength="100" Text='<%# Bind("DocNo") %>'></asp:TextBox>                                   
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lblDocno" runat="server" Text='<%# Eval("DocNo") %>'></asp:Label>
                                </ItemTemplate>
                            </telerik:GridTemplateColumn>                          
                            <telerik:GridTemplateColumn DataField="Category" HeaderText="Category"
                                SortExpression="Category" UniqueName="Category">
                                <EditItemTemplate>
                                    <telerik:RadComboBox ID="rcboCategory" runat="server">
                                        <CollapseAnimation Duration="200" Type="OutQuint" />
                                    </telerik:RadComboBox>
                                    <asp:RequiredFieldValidator ID="rfvCategory" runat="server" ControlToValidate="rcboCategory"
                                        ErrorMessage="*" ValidationGroup="FormValidation" InitialValue="-- SELECT --"></asp:RequiredFieldValidator>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lblCategory" runat="server" Text='<%# Eval("Category") %>'
                                        Width="113px"></asp:Label>
                                </ItemTemplate>
                            </telerik:GridTemplateColumn>                      
                            <telerik:GridTemplateColumn DataField="Description" HeaderText="Description" SortExpression="Description"
                                UniqueName="Description">
                                <EditItemTemplate>
                                    <asp:TextBox ID="txtDescription" runat="server" MaxLength="150" Width="350px" Text='<%# Bind("Description") %>'></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="rfvDescription" runat="server" ControlToValidate="txtDescription"
                                        ErrorMessage="*" ValidationGroup="FormValidation"></asp:RequiredFieldValidator>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lblDescription" runat="server" Text='<%# Eval("Description") %>'></asp:Label>
                                </ItemTemplate>
                            </telerik:GridTemplateColumn>
                            <telerik:GridTemplateColumn DataField="Currency" HeaderText="Currency"
                                SortExpression="Currency" UniqueName="Currency">
                                <EditItemTemplate>
                                    <telerik:RadComboBox ID="rcboCurrency" runat="server">
                                        <CollapseAnimation Duration="200" Type="OutQuint" />
                                    </telerik:RadComboBox>
                                    <asp:RequiredFieldValidator ID="rfvCurrency" runat="server" ControlToValidate="rcboCurrency"
                                        ErrorMessage="*" ValidationGroup="FormValidation" InitialValue="-- SELECT --"></asp:RequiredFieldValidator>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lblCurrency" runat="server" Text='<%# Eval("Currency") %>'
                                        Width="113px"></asp:Label>
                                </ItemTemplate>
                            </telerik:GridTemplateColumn>
                            <telerik:GridTemplateColumn DataField="ExRate" HeaderText="Ex Rate" DataType="System.Decimal" SortExpression="ExRate" UniqueName="ExRate">
                                <EditItemTemplate>
                                    <telerik:RadNumericTextBox ID="txtExRate" runat="server" DbValue='<%# Eval("ExRate") %>' >
                                                  <numberformat DecimalDigits="5" />                                       
                                    </telerik:RadNumericTextBox>
                                    <asp:RequiredFieldValidator ID="rfvExRate" runat="server" ControlToValidate="txtExRate"
                                        ErrorMessage="*" ValidationGroup="FormValidation" ></asp:RequiredFieldValidator>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lblExRate" runat="server" Text='<%# Eval("ExRate") %>'
                                        Width="113px"></asp:Label>
                                </ItemTemplate>
                            </telerik:GridTemplateColumn>
                            <telerik:GridTemplateColumn DataField="Amount" HeaderText="Amount" DataType="System.Decimal" SortExpression="Amount" UniqueName="Amount">
                                <EditItemTemplate>
                                    <telerik:RadNumericTextBox ID="txtAmount" runat="server" DbValue='<%# Eval("Amount") %>'>
                                                  <numberformat DecimalDigits="2" />                                       
                                    </telerik:RadNumericTextBox>
                                    <asp:RequiredFieldValidator ID="rfvAmount" runat="server" ControlToValidate="txtAmount"
                                        ErrorMessage="*" ValidationGroup="FormValidation" ></asp:RequiredFieldValidator>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lblAmount" runat="server" Text='<%# Eval("Amount","{0:0.00}") %>'
                                        Width="113px"></asp:Label>
                                </ItemTemplate>
                            </telerik:GridTemplateColumn>
                            <%--<telerik:GridNumericColumn DataField="Amount" DataType="System.Decimal" HeaderText="Amount" HeaderStyle-HorizontalAlign="Right"
                        ItemStyle-HorizontalAlign="Right" ReadOnly="false" UniqueName="Amount" />--%>
                            <telerik:GridTemplateColumn DataField="AmountSGD" HeaderText="AmountSGD" SortExpression="AmountSGD" UniqueName="AmountSGD" DataType="System.Decimal" >                        
                               <ItemTemplate>
                                    <asp:Label ID="lblAmountSGD" runat="server" Text='<%# Eval("AmountSGD") %>'></asp:Label>
                                </ItemTemplate>
                            </telerik:GridTemplateColumn>
                            <telerik:GridTemplateColumn DataField="Remarks" HeaderText="Comments" SortExpression="Remarks" UniqueName="Remarks">
                                <EditItemTemplate>
                                    <asp:TextBox ID="txtComments" runat="server" TextMode="MultiLine"  MaxLength="150" Width="350px" Text='<%# Bind("Remarks") %>'></asp:TextBox>  
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lblComments" runat="server" Text='<%# Eval("Remarks") %>'></asp:Label>
                                </ItemTemplate>
                            </telerik:GridTemplateColumn>
                            <telerik:GridTemplateColumn DataField="ChargeType" HeaderText="Charge Type" SortExpression="ChargeType" UniqueName="ChargeType">
                                <EditItemTemplate>
                                    <telerik:RadComboBox ID="rcboChargeType" runat="server">
                                        <CollapseAnimation Duration="200" Type="OutQuint" />
                                    </telerik:RadComboBox>
                                    <asp:RequiredFieldValidator ID="rfvChargeType" runat="server" ControlToValidate="rcboChargeType"
                                        ErrorMessage="*" ValidationGroup="FormValidation" InitialValue="-- SELECT --"></asp:RequiredFieldValidator>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lblChargeType" runat="server" Text='<%# Eval("ChargeType") %>'
                                        Width="113px"></asp:Label>
                                </ItemTemplate>
                            </telerik:GridTemplateColumn>
                            <telerik:GridTemplateColumn DataField="ChargeCode" HeaderText="Project No." SortExpression="ChargeCode" UniqueName="ChargeCode">
                                <EditItemTemplate>
                                    <telerik:RadComboBox ID="rcboChargeCode" runat="server" Filter="Contains" EnableLoadOnDemand="true" Width="350px" >
                                        <CollapseAnimation Duration="200" Type="OutQuint" />
                                    </telerik:RadComboBox>
                                    <asp:RequiredFieldValidator ID="rfvChargeCode" runat="server" ControlToValidate="rcboChargeCode"
                                        ErrorMessage="*" ValidationGroup="FormValidation" InitialValue="-- SELECT --"></asp:RequiredFieldValidator>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lblChargeCode" runat="server" Text='<%# Eval("ChargeCode") %>'
                                        Width="113px"></asp:Label>
                                </ItemTemplate>
                            </telerik:GridTemplateColumn>                          
                             
                        </Columns>
                        <EditFormSettings>
                            <PopUpSettings Width="500px" />
                            <EditColumn UniqueName="EditCommandColumn1">                           
                            </EditColumn>
                        </EditFormSettings>
                    </MasterTableView>
                    <GroupingSettings CaseSensitive="False" />
                </telerik:RadGrid></td>

    <telerik:RadScriptManager ID="RadScriptManager" runat="server">
    </telerik:RadScriptManager>
    <telerik:RadStyleSheetManager ID="RadStyleSheetManager1" runat="server">
    </telerik:RadStyleSheetManager>
    <asp:ValidationSummary ID="ValidationSummary1" runat="server" HeaderText="Validation Summary"
                    Height="1px" ShowMessageBox="True" ShowSummary="False" Width="196px" />
    <telerik:RadAjaxManager ID="RadAjaxManager" runat="server">
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="rdGEDetails">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="rdGEDetails" LoadingPanelID="RadAjaxLoadingPanel1"></telerik:AjaxUpdatedControl>
                </UpdatedControls>
            </telerik:AjaxSetting>
            <telerik:AjaxSetting AjaxControlID="PanelAT">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="PanelAT" LoadingPanelID="RadAjaxLoadingPanel1"></telerik:AjaxUpdatedControl>
                </UpdatedControls>
            </telerik:AjaxSetting>
        </AjaxSettings>    
    </telerik:RadAjaxManager>


using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using eClaims.DAL;
using eClaims.DAL.SqlClient;
using eClaims.Entities;
using eClaims.Services;
using Telerik.Web.UI;
using e_Claims;
 
namespace eClaims.Forms.GeneralExpense
{
    
    public partial class GECForm : System.Web.UI.Page
    {
        private static string _GECid;
         
        protected GeneralExpenseClaimService ser_GEC = new GeneralExpenseClaimService();
        protected GeneralExpenseClaimDetailService ser_GECD = new GeneralExpenseClaimDetailService();
        protected GeneralExpenseClaimDetail ent_GECD = new GeneralExpenseClaimDetail();
        protected ExcRateService ser_ExcRate = new ExcRateService();
        protected ExcRateQuery qry_ExcRate = new ExcRateQuery();
        private static TList<GeneralExpenseClaimDetail> list_GECD = new TList<GeneralExpenseClaimDetail>();
 
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                //_GECid=Request.QueryString.Get("GECid");
                setValue();
           
            }
        }
 
        private void setValue()
        {
            list_GECD = new TList<GeneralExpenseClaimDetail>();
            _GECid=null;
        }
 
        protected void rdGEDetails_DeleteCommand(object source, Telerik.Web.UI.GridCommandEventArgs e)
        {
            GridEditableItem editedItem = e.Item as GridEditableItem;
            string key = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["GeneralExpenseDetailID"].ToString();
            try
            {
                int index = list_GECD.FindIndex(
                    delegate(GeneralExpenseClaimDetail ent_GEC)
                    {
                        return ent_GEC.GeneralExpenseDetailID == new Guid(key);
                    });
 
                if (index >= 0)
                {                 
                    list_GECD.RemoveAt(index);
                }
                else
                {
                    this.setMessage("Failed to delete the claim.");
                }
            }
            catch (Exception ex)
            {
            }
        }
 
        protected void rdGEDetails_InsertCommand(object source, Telerik.Web.UI.GridCommandEventArgs e)
        {
            Boolean insSuccess = true;
            decimal amountSGD;
            GridEditFormInsertItem insertedItem = (GridEditFormInsertItem)e.Item;
 
            if ((insertedItem.FindControl("rcboChargeCode") as RadComboBox).SelectedValue.Length == 0)
            {
                setMessage("Invalid project charge code");
                insSuccess = false;
            }          
  
 
            try
            {
                if (insSuccess)
                {
                    ent_GECD.GeneralExpenseDetailID = Guid.NewGuid();                   
                    ent_GECD.GeneralDate = (insertedItem.FindControl("radDocdate") as RadDatePicker).SelectedDate;
                    ent_GECD.DocNo = (insertedItem.FindControl("txtDocno") as TextBox).Text;
                    ent_GECD.Category = (insertedItem.FindControl("rcboCategory") as RadComboBox).SelectedValue;
                    ent_GECD.Description = (insertedItem.FindControl("txtDescription") as TextBox).Text;
                    ent_GECD.Currency = (insertedItem.FindControl("rcboCurrency") as RadComboBox).SelectedValue;
                    try
                    {ent_GECD.ExRate = Convert.ToDecimal((insertedItem.FindControl("txtExRate") as RadNumericTextBox).Text);}
                    catch{}
                    try
                    { ent_GECD.Amount = Convert.ToDecimal((insertedItem.FindControl("txtAmount") as RadNumericTextBox).Text); }
                   // { ent_GECD.Amount= Convert.ToDecimal((insertedItem["Amount"].Controls[0] as RadNumericTextBox).Text);}
                    catch { }
                    amountSGD = ent_GECD.Amount.Value * ent_GECD.ExRate.Value;
                    try
                    {ent_GECD.AmountSGD = Convert.ToDecimal(amountSGD.ToString("#.##"));}
                    catch{}
                    ent_GECD.Remarks = (insertedItem.FindControl("txtComments") as TextBox).Text;
                    ent_GECD.ChargeType = (insertedItem.FindControl("rcboChargeType") as RadComboBox).SelectedValue;
                    ent_GECD.ChargeCode = (insertedItem.FindControl("rcboChargeCode") as RadComboBox).SelectedValue;
 
                    list_GECD.Add(ent_GECD);
                    this.rdGEDetails.DataSource = list_GECD;
 
                }
                else
                { e.Canceled = true; }
            }
            catch (Exception ex)
            {
                e.Canceled = true;
                this.setMessage(ex.ToString());
            }
        }
 
        protected void rdGEDetails_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
        {
            if ((e.Item is GridEditFormItem) && e.Item.IsInEditMode)
            {
                GridEditFormItem gridEditFormItem = (GridEditFormItem)e.Item;
 
                RadComboBox rcboCategory = gridEditFormItem["Category"].FindControl("rcboCategory") as RadComboBox;
                rcboCategory.DataSource = DataRepository.Provider.ExecuteDataSet(System.Data.CommandType.Text,
                                            "SELECT * from ExpenseType where formname='GEC'");
                rcboCategory.DataTextField = "ExpDesc";
                rcboCategory.DataValueField = "ExpCode";
                rcboCategory.DataBind();
                rcboCategory.Items.Insert(0, new RadComboBoxItem("-- SELECT --", "0"));
                rcboCategory.SelectedValue = CommonValidator.comboSelectedValue(DataBinder.Eval(e.Item.DataItem, "Category"));
 
                RadComboBox rcboCurrency = gridEditFormItem["Currency"].FindControl("rcboCurrency") as RadComboBox;
                rcboCurrency.DataSource = ser_ExcRate.Find(null, "Currency ASC");
                rcboCurrency.DataTextField = "Currency";
                rcboCurrency.DataValueField = "Currency";
                rcboCurrency.DataBind();
                rcboCurrency.Items.Insert(0, new RadComboBoxItem("-- SELECT --", "0"));
                rcboCurrency.SelectedValue = CommonValidator.comboSelectedValue(DataBinder.Eval(e.Item.DataItem, "Currency"));
 
                RadComboBox rcboProjectType = gridEditFormItem["ChargeType"].FindControl("rcboChargeType") as RadComboBox;               
                rcboProjectType.Items.Insert(0, new RadComboBoxItem("-- SELECT --", "0"));
                rcboProjectType.Items.Insert(1, new RadComboBoxItem("Project No", "Project No"));
                rcboProjectType.Items.Insert(2, new RadComboBoxItem("Cost Center", "Cost Center"));
                rcboProjectType.Items.Insert(3, new RadComboBoxItem("Order", "Order"));
                rcboProjectType.Items.Insert(4, new RadComboBoxItem("Sales Order", "Sales Order"));
                rcboProjectType.SelectedValue = CommonValidator.comboSelectedValue(DataBinder.Eval(e.Item.DataItem, "ChargeType"));
          
                RadComboBox rcboChargeCode = gridEditFormItem["ChargeCode"].FindControl("rcboChargeCode") as RadComboBox;        
                if (rcboProjectType.SelectedValue == "Project No")
                {
                    rcboChargeCode.ClearSelection();
                    rcboChargeCode.Text = "";
                    rcboChargeCode.DataSource = DataRepository.Provider.ExecuteDataSet(System.Data.CommandType.Text,
                                                "SELECT *,pspnr+'      '+post1 as merge FROM Project where s_sperr <> 'x' or s_sperr=''");
                    rcboChargeCode.DataTextField = "merge";
                    rcboChargeCode.DataValueField = "pspnr";
                    rcboChargeCode.DataBind();                       
                }
                else if (rcboProjectType.SelectedValue == "Cost Center")
                {
                    rcboChargeCode.ClearSelection();
                    rcboChargeCode.Text = "";
                    rcboChargeCode.DataSource = DataRepository.Provider.ExecuteDataSet(System.Data.CommandType.Text,
                                                "SELECT * ,kostl+'      '+ktext_en as merge  FROM CostCenter where kokrs='2610'");
                    rcboChargeCode.DataTextField = "merge";
                    rcboChargeCode.DataValueField = "kostl";
                    rcboChargeCode.DataBind();                       
                }
                else if (rcboProjectType.SelectedValue == "Order")
                {
                    rcboChargeCode.ClearSelection();
                    rcboChargeCode.Text = "";
                    rcboChargeCode.DataSource = DataRepository.Provider.ExecuteDataSet(System.Data.CommandType.Text,
                                                "SELECT *,aufnr+'      '+ktext as merge FROM [Order] where s_sperr <> 'x' or s_sperr='' order by aufnr");
                    rcboChargeCode.DataTextField = "merge";
                    rcboChargeCode.DataValueField = "aufnr";
                    rcboChargeCode.DataBind();                       
                }
                else if (rcboProjectType.SelectedValue == "Sales Order")
                {
                    rcboChargeCode.ClearSelection();
                    rcboChargeCode.Text = "";
                    rcboChargeCode.DataSource = DataRepository.Provider.ExecuteDataSet(System.Data.CommandType.Text,
                                                "SELECT *,quot+'      '+description as merge FROM SalesOrder where S_Lock <> 'x' or S_Lock='' ");
                    rcboChargeCode.DataTextField = "merge";
                    rcboChargeCode.DataValueField = "quot";
                    rcboChargeCode.DataBind();                       
                }
                else
                {
                    //rcboChargeCode.DataSource = null;
                    //rcboChargeCode.DataBind();
                }
                rcboChargeCode.SelectedValue = CommonValidator.comboSelectedValue(DataBinder.Eval(e.Item.DataItem, "ChargeCode"));
                }
            }
 
        protected void btnSave_Click(object sender, EventArgs e)
        {  
             
            string sqn=CommonFunctions.GetSeqNo(ConstantResource.ClaimType.CTGeneralExpenseClaim);   
        }
        protected void rdGEDetails_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
        {
            this.rdGEDetails.DataSource = list_GECD;
        }
 
        protected void rdGEDetails_UpdateCommand(object source, Telerik.Web.UI.GridCommandEventArgs e)
        {
 
        }
        protected void setMessage(string message)
        {
            this.RadAjaxManager.Alert(message);
        }
 
        protected void rdGEDetails_ItemCreated(object sender, GridItemEventArgs e)
        {
            if (e.Item is GridEditableItem && e.Item.IsInEditMode)
            {
                //the dropdown list will be the first control in the Controls collection of the corresponding cell
                RadComboBox list = (e.Item as GridEditableItem)["Currency"].FindControl("rcboCurrency") as RadComboBox;    
                //attach SelectedIndexChanged event for the combobox control
                list.AutoPostBack = true;
                list.CausesValidation = false;
                list.SelectedIndexChanged += new RadComboBoxSelectedIndexChangedEventHandler(list_SelectedIndexChanged);
 
                //the dropdown list will be the first control in the Controls collection of the corresponding cell
                RadComboBox projlist = (e.Item as GridEditableItem)["ChargeType"].FindControl("rcboChargeType") as RadComboBox;
                //attach SelectedIndexChanged event for the combobox control
                projlist.AutoPostBack = true;
                projlist.CausesValidation = false;
                projlist.SelectedIndexChanged += new RadComboBoxSelectedIndexChangedEventHandler(projlist_SelectedIndexChanged);
 
                 
            }
        }
        void list_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)
        {
            //first reference the edited grid item through the NamingContainer attribute
            GridEditableItem editedItem = (sender as RadComboBox).NamingContainer as GridEditableItem;
 
            //the dropdown list will be the first control in the Controls collection of the corresponding cell
            //for custom edit forms (WebUserControl/FormTemplate) you can find the column editor with the FindControl(controlId) method
            RadNumericTextBox txtExchangeRate = editedItem["ExRate"].FindControl("txtExRate") as RadNumericTextBox;
 
            qry_ExcRate.AppendEquals(ExcRateColumn.Currency, (editedItem["Currency"].FindControl("rcboCurrency") as RadComboBox).SelectedValue);
            txtExchangeRate.Text = ser_ExcRate.Find(qry_ExcRate.GetParameters())[0].Rate.HasValue ? ser_ExcRate.Find(qry_ExcRate.GetParameters())[0].Rate.ToString() : "0";                
 
        }
 
        void projlist_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)
        {
            //first reference the edited grid item through the NamingContainer attribute
            GridEditableItem editedItem = (sender as RadComboBox).NamingContainer as GridEditableItem;
            RadComboBox ddList = editedItem["ChargeCode"].FindControl("rcboChargeCode") as RadComboBox;
            //the dropdown list will be the first control in the Controls collection of the corresponding cell
            //for custom edit forms (WebUserControl/FormTemplate) you can find the column editor with the FindControl(controlId) method
            string projecttype = (editedItem["ChargeType"].FindControl("rcboChargeType") as RadComboBox).SelectedValue.ToString();
             
            if (projecttype == "Project No")
            {               
                ddList.ClearSelection();
                ddList.Text = "";
                ddList.DataSource = DataRepository.Provider.ExecuteDataSet(System.Data.CommandType.Text,
                                            "SELECT *,pspnr+'      '+post1 as merge FROM Project where s_sperr <> 'x' or s_sperr=''");
                ddList.DataTextField = "merge";
                ddList.DataValueField = "pspnr";
                ddList.DataBind();
            }
            else if (projecttype == "Cost Center")
            {               
                ddList.ClearSelection();
                ddList.Text = "";
                ddList.DataSource = DataRepository.Provider.ExecuteDataSet(System.Data.CommandType.Text,
                                            "SELECT * ,kostl+'      '+ktext_en as merge  FROM CostCenter where kokrs='2610'");
                ddList.DataTextField = "merge";
                ddList.DataValueField = "kostl";  
                ddList.DataBind();
            }
            else if (projecttype == "Order")
            {
                ddList.ClearSelection();
                ddList.Text = "";
                ddList.DataSource = DataRepository.Provider.ExecuteDataSet(System.Data.CommandType.Text,
                                            "SELECT *,aufnr+'      '+ktext as merge FROM [Order] where s_sperr <> 'x' or s_sperr='' order by aufnr");
                ddList.DataTextField = "merge";
                ddList.DataValueField = "aufnr";  
                ddList.DataBind();
            }
            else if (projecttype == "Sales Order")
            {               
                ddList.ClearSelection();
                ddList.Text = "";
                ddList.DataSource = DataRepository.Provider.ExecuteDataSet(System.Data.CommandType.Text,
                                            "SELECT *,quot+'      '+description as merge FROM SalesOrder where S_Lock <> 'x' or S_Lock='' ");
                ddList.DataTextField = "merge";
                ddList.DataValueField = "quot";  
                ddList.DataBind();
            }
            else { }
        }
    }
}
Martin
Telerik team
 answered on 16 Mar 2011
3 answers
118 views
Hi,

I have a RadEditor that is using ToolbarMode="ShowOnFocus".  After upgrading to the Q2 release, the RadEditor no longer displays properly when first displayed.

Thanks
Rao
Rumen
Telerik team
 answered on 16 Mar 2011
1 answer
116 views
Hi


I have problem in grid senario.
Firstly I have a grid an buton in the page.
I click the buton then I take the grids item row by row.I take the Address in grid's item then ı  execute this address to google map the google map send me a accuarcy for result.
For this accuarcy,If the accuarcy 1 the processed row's color red in that time.But I click the buton after that all result shown me same time.
I want to this proccess row by row.Can you help me?How can I do this senerio.


Best regards 

Suleyman Cebesoy
Tsvetina
Telerik team
 answered on 16 Mar 2011
1 answer
87 views
Hi,

I just wanted to know  what are all the new functionality added in the new version of the Rad Editor? Also what are all the Bugs Fixed in this new version? Is there any place where i can go and find all the information....

Thanks
Stanimir
Telerik team
 answered on 16 Mar 2011
1 answer
348 views
Hi All,

I have a RadGrid in my page. I'm neither binding it on client side nor in server side, and on initial load RadGrid appears with 11 empty rows; instaed of empty grid with EmptyMessage.

I just want to drag and drop a RadGrid and on initial load get a radgrid with emptyMessage instead of 11 blank rows. How can i achieve this?

Thanks in advance for helping.
Princy
Top achievements
Rank 2
 answered on 16 Mar 2011
4 answers
292 views
Is there a way that when i close the window the Page gets unloaded.

My example is a page with a flash control in it with sound.  when i click the X to close the window closes but the page is still loaded and the music still plays.  Is there a way around this?


<EDIT>
I found the answer right after my post

DestroyOnClose
Georgi Tunev
Telerik team
 answered on 16 Mar 2011
1 answer
125 views
Hello,

I'm new to telerik and using ASP.NET3.5 / C#.
I'm trying to have a TabStrip using it as a Wizard just like the Demo on the telerik site. The only difference is I want to have a Preview ascx as one of the TabStrip instead of having it displayed beside the TabStrip.

I'm having a issue with updating the value in 'Preview' tab.
For first entries on each Tab go correctly on 'Preview' tab, however if I go back to the tab such as 'Personal Info' tab, make some modifications and keep clicking 'Next' button to see the last 'Preview' tab, modifications aren't reflected on 'Preview' tab correctly. The information on 'Preview' tab just stays as first entries.
I'm using 'RadAjaxPanel' same as Demo uses. I also tried to use 'RadAjaxManager' instead, but it didn't work.

What am I missing? What should I have?

Any suggestion would be appreciated.
Thank you in advance,

RS
RS
Top achievements
Rank 1
 answered on 16 Mar 2011
0 answers
63 views
Hi Everybody,

I am using RadGrid to show the report like structure. Here I am having a problem with expansion of a column. I have a column named Notes where the information contains at least 50 letters. While displaying those 50 letters in Grid where it is assigned to a label is expanding the RadGrid.

Now I need a solution that since I have 50 letters I will just show them 10 letters instead of 50 letters in that cell. for example:

50 letters: Application time search by school Roll Number.

I want to show it as

Application time....

Whenever any person hovers on that cell it must show entire 50 words. By this we can reduce the expansion of RadGrid hopefully.

Help me in achieving this functionality.

Thank you
BRK
Top achievements
Rank 1
 asked on 16 Mar 2011
2 answers
175 views
Hi everybody,
 Hard coded the Treeview in  TreeviewBinding() Event. And we used the control in this way.
 For this there is a master Page and the Treeview code we kept in child page.


<telerik:RadTreeView ID="supview" runat="server" DataFieldID="child_id" DataFieldParentID="parent_id" CheckBoxes="true" >
          <DataBindings>
                    <telerik:RadTreeNodeBinding  Enabled="true"  />
                  </DataBindings>
                  
                  
          </telerik:RadTreeView>

Help me that I activate the events.
Thanking you
BRK
Top achievements
Rank 1
 answered on 16 Mar 2011
1 answer
95 views

In the hierarchy grid the allowrowselect is set to true. How can I tell if the row selected is from the master table view or detail table view on the client side script (rowselected). Please advise.

Thanks
RJ

Princy
Top achievements
Rank 2
 answered on 16 Mar 2011
Narrow your results
Selected tags
Tags
+? more
Top users last month
Bohdan
Top achievements
Rank 3
Iron
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Elliot
Top achievements
Rank 1
Iron
Iron
Iron
Sunil
Top achievements
Rank 1
Cynthia
Top achievements
Rank 1
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Bohdan
Top achievements
Rank 3
Iron
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Elliot
Top achievements
Rank 1
Iron
Iron
Iron
Sunil
Top achievements
Rank 1
Cynthia
Top achievements
Rank 1
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?