Telerik Forums
UI for ASP.NET AJAX Forum
1 answer
105 views
heeey guys 


I have a question, I have  here a data time field that is saved in the db as date time and it need to be a date time , and I want to load this Field in a drop down but not the hole value just the year 

}
     protected void LoadYear()
     {
         SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["HolidayTrackerConnectionString"].ConnectionString);
 
         SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM HtVacationDay", connection);
         DataTable dt = new DataTable();
 
         adapter.Fill(dt);
 
         rcbYear.DataTextField = "FromDate";
         rcbYear.DataValueField = "VacationDayId";
 
         rcbYear.DataSource = dt;
         rcbYear.DataBind();
 
         rcbYear.Items.Insert(0, new RadComboBoxItem("-Select a Year-"));
     }
thanks for help and fast answer ! 
Shinu
Top achievements
Rank 2
 answered on 15 Nov 2012
2 answers
468 views
Hi all member
I have a grid in asp and add
GridColumnGroup and column in code behind.
i add in page load event before i set value for colums but when page post back to server raise error
Invalid column name:
this my code

plase help to me
thanks

protected void Page_Load(object sender, EventArgs e)
       {
           if (Page.IsPostBack == false)
           {
               txtDate.Text = clsMain.GetPersianDate();
                
               CreateStructureTable();
               fillZoneData();
               fillAreaData();
               fillPlacetype();
               if (objZone.dtblZone.Rows.Count == 0 || objArea.dtblZone.Rows.Count==0)
               {
                   string script = "Error('شما به منطقه ای مشخص دسترسی ندارید')";
                  // ScriptManager.RegisterStartupScript(this, GetType(), "MyKey", script, true);
               }
               else
               {
                   FillPlaceInTable();
                   FillDataInTable();
                     
               }
           }
       }
private void CreateStructureTable()
       {
           int i = 0;
           string s = "";
           #region "GridClear"
           dgdZone.MasterTableView.Columns.Clear();
          // dgdZone0.MasterTableView.Columns.Clear();
           dgdZone.MasterTableView.ColumnGroups.Clear();
           #endregion
           
           #region "GridColumnGroup"
           objContractItem.dtblContractItem = clsMain.SelectByCondition("Select * from vContractItem where iNumber In(Select iParentNumber from vContractItem) Order by ContractItemLevel asc");
           for (i = 0; i <= objContractItem.dtblContractItem.Rows.Count - 1; i++)
           {
               if (!dgdZone.MasterTableView.ColumnGroups.Contains(objContractItem.dtblContractItem.Rows[i]["iNumber"]))
               {
                   GridColumnGroup grp = new GridColumnGroup();
                   grp.HeaderText = objContractItem.dtblContractItem.Rows[i]["strName"].ToStr().Replace(" ", "").Replace(":", "");
                   grp.Name = "grp" + objContractItem.dtblContractItem.Rows[i]["iNumber"].ToStr().Replace(" ", "").Replace(":", "");
                   grp.HeaderStyle.VerticalAlign = VerticalAlign.Middle;
                   grp.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
                   if (objContractItem.dtblContractItem.Rows[i]["iParentNumber"].ToInt() != 0)
                   {
                       grp.ParentGroupName = "grp" + objContractItem.dtblContractItem.Rows[i]["iParentNumber"].ToStr().Replace(" ", "").Replace(":", "");
                   }
                   dgdZone.MasterTableView.ColumnGroups.Add(grp);
               }
           }
           #endregion
           //------------------------------ردیف
           Telerik.Web.UI.GridBoundColumn iRowNumber = new Telerik.Web.UI.GridBoundColumn();
           dgdZone.MasterTableView.Columns.Add(iRowNumber);
           //dgdZone0.MasterTableView.Columns.Add(iRowNumber);
           iRowNumber.HeaderText = "ردیف";
           iRowNumber.UniqueName = "iRowNumber";
           iRowNumber.DataField = "iRowNumber";
           iRowNumber.Visible = true;
           iRowNumber.HeaderStyle.Width = Unit.Pixel(40);
           iRowNumber.ItemStyle.Width = Unit.Pixel(20);
           iRowNumber.ForceExtractValue = GridForceExtractValues.Always;
           iRowNumber.AllowFiltering = false;
           iRowNumber.HeaderStyle.VerticalAlign = VerticalAlign.Middle;
           iRowNumber.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
           iRowNumber.ItemStyle.VerticalAlign = VerticalAlign.Middle;
           iRowNumber.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
           dt.Columns.Add("iRowNumber", i.GetType());
           dt2.Columns.Add("iRowNumber", s.GetType());
           //------------------------------------------
           //------------------------شناسه محل
           Telerik.Web.UI.GridBoundColumn iZonePlaceNumberCol = new Telerik.Web.UI.GridBoundColumn();
           dgdZone.MasterTableView.Columns.Add(iZonePlaceNumberCol);
         //  dgdZone0.MasterTableView.Columns.Add(iZonePlaceNumberCol);
           iZonePlaceNumberCol.HeaderText = "iZonePlaceNumber";
           iZonePlaceNumberCol.UniqueName = "iZonePlaceNumber";
           iZonePlaceNumberCol.DataField = "iZonePlaceNumber";
           iZonePlaceNumberCol.Visible = false;
           iZonePlaceNumberCol.ForceExtractValue = GridForceExtractValues.Always;
           dt.Columns.Add("iZonePlaceNumber", i.GetType());
           dt.Columns.Add("strPlaceName", s.GetType());
           //------------------------------
           //--------------------------------نام محل
          
           Telerik.Web.UI.GridBoundColumn strPlaceNameCol = new Telerik.Web.UI.GridBoundColumn();
           dgdZone.MasterTableView.Columns.Add(strPlaceNameCol);
         //  dgdZone0.MasterTableView.Columns.Add(strPlaceNameCol);
           strPlaceNameCol.HeaderText = "نام محل";
           strPlaceNameCol.UniqueName = "strPlaceName";
           strPlaceNameCol.DataField = "strPlaceName";
           strPlaceNameCol.Visible = true;
           strPlaceNameCol.HeaderStyle.Width = Unit.Pixel(180);
           strPlaceNameCol.ItemStyle.Width = Unit.Pixel(180);
           strPlaceNameCol.ForceExtractValue = GridForceExtractValues.Always;
           strPlaceNameCol.AllowFiltering = false;
           strPlaceNameCol.HeaderStyle.VerticalAlign = VerticalAlign.Middle;
           strPlaceNameCol.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
           strPlaceNameCol.ItemStyle.VerticalAlign = VerticalAlign.Middle;
           strPlaceNameCol.ItemStyle.HorizontalAlign = HorizontalAlign.Right;
           strPlaceNameCol.AllowSorting = false;
           strPlaceNameCol.AllowFiltering = false;
           dt2.Columns.Add("iZonePlaceNumber", i.GetType());
           dt2.Columns.Add("strPlaceName", s.GetType());
           //------------------------------
            
            
           objContractItem.dtblContractItem = clsMain.SelectByCondition("Select * from vContractItem where bShowDailyReport=1" + " Order by iParentNumber asc");
           for (i = 0; i <= objContractItem.dtblContractItem.Rows.Count - 1; i++)
           {
               Telerik.Web.UI.GridBoundColumn col = new Telerik.Web.UI.GridBoundColumn();
               if (objContractItem.dtblContractItem.Rows[i]["bIncomplete"].ToBool() == true)
               {
                 //  dgdZone0.MasterTableView.Columns.Add(col);
                   dt2.Columns.Add(objContractItem.dtblContractItem.Rows[i]["iNumber"].ToString(), i.GetType());
               }
               else
               {
                   dgdZone.MasterTableView.Columns.Add(col);
                   dt.Columns.Add(objContractItem.dtblContractItem.Rows[i]["iNumber"].ToString(), i.GetType());
               }
               if (objContractItem.dtblContractItem.Rows[i]["iParentNumber"].ToStr().Length > 0)
               {
                   //col.ColumnGroupName = "grp" + objContractItem.dtblContractItem.Rows[i]["iParentNumber"].ToStr();
               }
               col.UniqueName =objContractItem.dtblContractItem.Rows[i]["iNumber"].ToString();
               col.DataField = objContractItem.dtblContractItem.Rows[i]["iNumber"].ToString();
               col.ForceExtractValue = GridForceExtractValues.Always;
               col.HeaderText = objContractItem.dtblContractItem.Rows[i]["strName"].ToString();
               col.HeaderStyle.VerticalAlign = VerticalAlign.Middle;
               col.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
               col.ItemStyle.VerticalAlign = VerticalAlign.Middle;
               col.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
               col.HeaderStyle.Width = Unit.Pixel(100);
               col.AllowSorting = false;
               col.AllowFiltering = false;
               col.Groupable = false;
           }
           // }
           GlobalMActivity.dt = dt;
           GlobalMActivity.dt2 = dt2;
           dgdZone.DataSource = dt;
           //dgdZone0.DataSource = dt2;
           dgdZone.DataBind();
        //   dgdZone0.DataBind();
       }
Eyup
Telerik team
 answered on 15 Nov 2012
1 answer
352 views
I have the following example code in content page:


...
<script>
 function pbBtn1() {
         __doPostBack("button1", "")
     }
      
    </script>
</asp:Content>
 
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server" >
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
     <AjaxSettings>
 
 
        <telerik:AjaxSetting AjaxControlID="button1">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="rts"
                        LoadingPanelID="RadAjaxLoadingPanel3" />
                    <telerik:AjaxUpdatedControl ControlID="rmp" LoadingPanelID="RadAjaxLoadingPanel3" />
                </UpdatedControls>
        </telerik:AjaxSetting>
 
 
               </AjaxSettings>
</telerik:RadAjaxManager>
    
    
   <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel3" runat="server" />
    
        <div class="mainContent_bg" >
            
            <div class="mainContentContainerContent">
                
               <div class="spessore10"></div>              
                    <br />
                     <br />
                  <div id="xls">
                            <telerik:RadTabStrip ID="rts" runat="server" MultiPageID="rmp" OnClientTabSelected="pbBtn1">
                            <Tabs>
                            <telerik:RadTab Text="page1" selected="true" PageViewID="page1"></telerik:RadTab>
                            <telerik:RadTab Text="page2" selected="false" PageViewID="page2"></telerik:RadTab>
                            </Tabs>
                            </telerik:RadTabStrip>
                            <telerik:RadMultiPage ID="rmp" runat="server">
                                <telerik:RadPageView runat=server ID="page1" Selected=true BorderColor="Black" Height=500 BackColor="Gray">
                                 <asp:Label ID=lb1 runat=server  Text="Label1 base"></asp:Label>
                                 <br />
                                  
                                </telerik:RadPageView>
                                <telerik:RadPageView runat=server ID="page2" BorderColor="Black" Height=500 BackColor="Gray">
                                    <asp:Label ID=lb2 runat=server  Text="Label2 base"></asp:Label>
                                   <br />
                                    <br />
                                     
                                </telerik:RadPageView>
                            </telerik:RadMultiPage>
                  </div>            
  
                  <telerik:radButton ID="button1" runat="server"  Text=button1 />
                  <asp:Button ID="button2" runat="server"  OnClientClick="pbBtn1()" Text=button2  />
 
For my project I need to refresh only radTabStrip e radmultipge when I do button1 postback ... if I write this code in aspx page without masterpage it works. m
I also try to write radscriptManager on masterpage and to use radAjaxManagerProxy in content page but it does not work.
What  I do wrong? 

Thanks,

Davide

Eyup
Telerik team
 answered on 15 Nov 2012
8 answers
682 views
Hi,
I have one rad combo box , text box and a submit button at my rad window popup. At the time close popup at 'OnClientClose' i have cleared the rad combo box selection at client side as per below snippet,
 var comboDeactivateReasonTruck = $find("<%= cboDeactivateReasonTruck.ClientID %>");            
                comboDeactivateReasonTruck.clearSelection();             
                comboDeactivateReasonTruck.commitChanges();

  but internally the event for that respective combobox is not cleared. So when i trying to click on submit now at that first time if we have any validation message then its working fine ,now we are close that window popup and reopen and click again on submit instead of that submit event combobox event has been fired and nothing is happened. Is there any solution for that..?

Thanks in Advance...

Regards,
Subbu
Vipin
Top achievements
Rank 1
 answered on 15 Nov 2012
2 answers
316 views
Is it possible Using RadFileExplorer want to show the folders and files from the common path(\\10.100.1.11\common$\). The common path was outside from the virtual directory.
balakrishnan
Top achievements
Rank 1
 answered on 15 Nov 2012
3 answers
525 views
Hello,
I am getting foll. error on click of rad editor's "Hyperlink Manager".

"Web.config registration missing!
 The Telerik dialogs require a HttpHandler registration in the web.config file. Please, use the control's Smart Tag to add the handler automatically, or see the help for more information: Controls > RadEditor > Dialogs > Introduction"

Server IIS version = 7.0
Telerik DLL version = Version=2010.3.1215.35

Please check my web.config -

<system.webServer>
        <validation validateIntegratedModeConfiguration="false"/>
        <modules>
            <remove name="ScriptModule"/>
            <remove name="RadUploadModule"/>
            <add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
            <add name="RadUploadModule" type="Telerik.Web.UI.RadUploadHttpModule" preCondition="integratedMode,runtimeVersionv2.0"/>
            <add name="RadCompression" type="Telerik.Web.UI.RadCompression"/>
        </modules>
        <handlers>
            <remove name="ChartImageHandler"/>
            <remove name="ChartImage_axd"/>
            <add name="ChartImageHandler" preCondition="integratedMode" verb="GET,HEAD,POST" path="ChartImg.axd" type="System.Web.UI.DataVisualization.Charting.ChartHttpHandler, System.Web.DataVisualization, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
            <remove name="WebServiceHandlerFactory-Integrated"/>
            <remove name="ScriptHandlerFactory"/>
            <remove name="ScriptHandlerFactoryAppServices"/>
            <remove name="ScriptResource"/>
            <remove name="Telerik_Web_UI_SpellCheckHandler_axd"/>
            <remove name="Telerik_Web_UI_DialogHandler_aspx"/>
            <remove name="Telerik_RadUploadProgressHandler_ashx"/>
            <remove name="Telerik_Web_UI_WebResource_axd"/>
            <add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
            <add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
            <add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
            <add name="Telerik_Web_UI_SpellCheckHandler_axd" path="Telerik.Web.UI.SpellCheckHandler.axd" type="Telerik.Web.UI.SpellCheckHandler" verb="*" preCondition="integratedMode,runtimeVersionv2.0"/>
            <add name="Telerik_Web_UI_DialogHandler_aspx" path="Telerik.Web.UI.DialogHandler.aspx" type="Telerik.Web.UI.DialogHandler" verb="*" preCondition="integratedMode,runtimeVersionv2.0"/>
            <add name="Telerik_RadUploadProgressHandler_ashx" path="Telerik.RadUploadProgressHandler.ashx" type="Telerik.Web.UI.RadUploadProgressHandler" verb="*" preCondition="integratedMode,runtimeVersionv2.0"/>
            <add name="Telerik_Web_UI_WebResource_axd" path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource" verb="*" preCondition="integratedMode,runtimeVersionv2.0"/>
            <add name="ChartImage_axd" path="ChartImage.axd" type="Telerik.Web.UI.ChartHttpHandler" verb="*" preCondition="integratedMode,runtimeVersionv2.0"/>
 
        </handlers>
 <rewrite>
            <rules>
                <rule name="RewriteASPX">
                    <match url="(.*)" />
                    <conditions logicalGrouping="MatchAll">
                        <add input="{REQUEST_FILENAME}" matchType="IsFile" negate="true" />
                        <add input="{REQUEST_FILENAME}" matchType="IsDirectory" negate="true" />
                        <add input="{URL}" pattern="WebResource.axd" negate="true"/>
                        <add input="{URL}" pattern="ScriptResource.axd" negate="true"/>
                        <add input="{URL}" pattern=".js" negate="true"/>
                    </conditions>
                    <action type="Rewrite" url="memberlogin.aspx?member={R:0}" />
                </rule>
            </rules>
        </rewrite>


    </system.webServer>

<httpHandlers>
           <remove verb="*" path="*.asmx"/>
           <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
           <add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
           <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>
 
           <add path="ChartImage.axd" verb="*" type="Telerik.Web.UI.ChartHttpHandler, Telerik.Web.UI, Version=2010.3.1215.35, Culture=neutral, PublicKeyToken=121fae78165ba3d4" validate="false"/>
           <add path="ChartImg.axd" verb="GET,HEAD,POST" type="System.Web.UI.DataVisualization.Charting.ChartHttpHandler, System.Web.DataVisualization, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false"/>
 
 
           <add verb="*" path="Telerik.RadUploadProgressHandler.ashx" type="Telerik.Web.UI.Upload.RadUploadProgressHandler, Telerik.Web.UI"/>
           <add verb="*" path="Telerik.Web.UI.DialogHandler.aspx" type="Telerik.Web.UI.DialogHandler, Telerik.Web.UI, Culture=neutral, PublicKeyToken=121fae78165ba3d4"></add>
           <add verb="*" path="Telerik.Web.UI.SpellCheckHandler.axd" type="Telerik.Web.UI.SpellCheckHandler, Telerik.Web.UI, Culture=neutral, PublicKeyToken=121fae78165ba3d4"></add>
           <add verb="*" path="ChartImage.axd" type="Telerik.Web.UI.ChartHttpHandler, Telerik.Web.UI, Culture=neutral, PublicKeyToken=121fae78165ba3d4" validate="false"/>
           <add path="Telerik.Web.UI.WebResource.axd" verb="*" type="Telerik.Web.UI.WebResource, Telerik.Web.UI" validate="false"/>
       </httpHandlers>
       <httpModules>
           <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
           <add name="RadUploadModule" type="Telerik.Web.UI.RadUploadHttpModule"/>
           <add name="RadCompression" type="Telerik.Web.UI.RadCompression"/>
           <add name="RadUploadModule" type="Telerik.Web.UI.RadUploadHttpModule, Telerik.Web.UI"/>
 
       </httpModules>
Tien
Top achievements
Rank 1
 answered on 15 Nov 2012
6 answers
370 views
I am using a radGrid inside an AbleCommerce website.

Have a couple of issues, Major #1:

Am using embedded grid styles, not custom styles at all. The Grid themes properly except for the Add/Refresh/Filter buttons.
When I look at the classes, the rgAdd classes are NOT being applied to my butttons, in comparison to the examples on the website.

There is a style.css for the website template, though I don't understand why the grid classes are not being applied at all the buttons.

Have attached screenshots showing Firebug inspection of the CSS.

Minor issue #2:
Have radComboBox in edit template for grid row. On first load the radCombo does not render properly, in fact the popup looks a bit mangled too. If close and open again, the popup window renders OK. If reload page, the issue starts again.


Thank you,

Pat.

Patrick Saunders
Top achievements
Rank 1
 answered on 15 Nov 2012
2 answers
110 views
Telerik,

I have a RadGrid that is bound on the client-side.  I would like to access the hyperlinkcolmn in the RowDataBount (client-side) function at set the "click" event.  I am having all sorts of trouble getting to the correct control.  Can you help me out?

Here is the HyperLinkColumn
<telerik:GridHyperlinkColumn UniqueName="RequestNumber" HeaderText="Request #" SortExpression="RequestNumber"
DataTextField="RequestNumber" HeaderStyle-Width="6em" AllowFiltering="false" />

Here is the client-side function I want to use to access the lyperlink click event:

   this.RowDataBound = function(sender, args) {
        var item = args.get_item();
        var dataItem = args.get_dataItem();
        var rowNumber = parseInt(item._itemIndexHierarchical);
};


Chris
Top achievements
Rank 1
 answered on 14 Nov 2012
3 answers
180 views
 I have a cart radbutton with a numeric total that is it's own control that sits on Default.aspx. The numeric total is called by a server side method.

I have a radwindow control that has the ability to add items to that cart.

Onclientclose of the radwindow, I need to find a way to refresh or postback that radbutton control to update my total cart items.

I DO NOT want the entire page to postback.

How can I accomplish this?
Geoff
Top achievements
Rank 1
 answered on 14 Nov 2012
3 answers
117 views
Hi,

I have a grid which has one gridtemplate column in which i have a link button. when clicked on this link button i am binding another grid. Now when i am exporting the data to pdf/excel i am not getting any data from the grid template column which has this link button. I need to have that as a link button. So can you please advice me on this? 

Thanks,
Swamy.
Daniel
Telerik team
 answered on 14 Nov 2012
Narrow your results
Selected tags
Tags
+? more
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?