When I drag and drop a selected row from ASP.NET Ajax (Telerik.web.ui) Radgrid (inside a usercontrol) to a RadTreeview node (inside a usercontrol),
I am able to capture the Datakeyitem of the Radgrid on the RowDrop serverside event of the Radgrid, like
Private Sub grdEquipments_RowDrop(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridDragDropEventArgs) Handles grdEquipments.RowDrop
Dim dataItem As GridDataItem = e.DraggedItems(0)
Dim s As String = dataItem.OwnerTableView().Items(dataItem.ItemIndex).GetDataKeyValue("ID")
End Sub
But I am not able to get the refrence to the Treeview Node on which the Item is being dropped.
Do you have any sample projects where you have this functinality.
please note that these two controls are in separate usercontrols.
Thanks
Madhu Rao
protected void imSearch_Click(object sender, EventArgs e)
{
TextBox txtFirstName = (TextBox)RadPanelBar1.FindItemByValue("QuickSearch").FindControl("txtFirstName");
}
<telerik:RadPanelBar runat="server" ID="RadPanelBar1" Width="100%" ExpandMode="SingleExpandedItem" Skin="Windows7" >
<Items>
<telerik:RadPanelItem Text="Quick Search" Expanded="True" runat="server" >
<Items>
<telerik:RadPanelItem runat="server" Value="QuickSearch" BorderColor="Red" >
<ItemTemplate>
<asp:Label ID="lblSearch" style="text-align:center" runat="server" Text="First Name:" Font-Bold="True" />
<telerik:RadTextBox ID="txtFirstName" runat="server" EmptyMessage="Search First Name" Skin="WebBlue" Width="130px"/>
Can anybody tell me what I'm missing.
<telerik:RadGrid ID="rgUsers" BorderColor="#cccccc" runat="server" AutoGenerateColumns="false" OnItemCommand="ItemCommand" OnUpdateCommand="ItemUpdated" AllowAutomaticUpdates="false"> <MasterTableView DataKeyNames="adminuser_id" Width="100%" EnableViewState="false" EditMode="PopUp"> <Columns> <telerik:GridBoundColumn DataField="email" HeaderText="Email Address" HeaderStyle-Width="25%" ItemStyle-VerticalAlign="Top" ReadOnly="true" /> <telerik:GridTemplateColumn HeaderText="Password" Visible="false" UniqueName="colPassword"> <EditItemTemplate> <asp:TextBox ID="tbPassword" runat="server" MaxLength="30" /> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridEditCommandColumn ButtonType="LinkButton" ItemStyle-CssClass="gridaction" EditText="Reset Password" HeaderStyle-Width="15%" /> </Columns> </MasterTableView> <ClientSettings> <Selecting AllowRowSelect="False" EnableDragToSelectRows="false" /> <Scrolling AllowScroll="true" UseStaticHeaders="true" /> </ClientSettings> </telerik:RadGrid>protected void ItemUpdated( object sender, GridCommandEventArgs args ){ AdminUser user = args.Item.DataItem as AdminUser; TextBox tbPassword = args.Item.FindControl( "tbPassword" ) as TextBox; SqlExecutor.Execute( delegate( SqlConnection connection ) { user.password = tbPassword.Text; user.Persist( connection ); }, logger );}string connString = ConfigurationManager.ConnectionStrings["AnswergenDB"].ConnectionString; SqlConnection sconn = new SqlConnection(connString); sconn.Open(); SqlCommand sqlcmd = new SqlCommand("sp_Pivot", sconn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add("@pivot", "column84"); sqlcmd.Parameters.Add("@table", "Level_Zero"); sqlcmd.Parameters.Add("@expr1", "SUM(Level_Zero.Column35)"); sqlcmd.Parameters.Add("@expr2", "SUM(Level_Zero.Column52)"); sqlcmd.Parameters.Add("@expr3", "SUM(Level_Zero.Column33)"); sqlcmd.Parameters.Add("@exprcolumn1", "Payroll"); sqlcmd.Parameters.Add("@exprcolumn2", "Total Billed"); sqlcmd.Parameters.Add("@exprcolumn3", "Op Income"); SqlDataReader pvtdr = sqlcmd.ExecuteReader(CommandBehavior.CloseConnection); DataTable pvtdt = new DataTable(); pvtdt.Load(pvtdr); string pvtqry = string.Empty; foreach (DataRow row in pvtdt.Rows) { for (int i = 0; i < pvtdt.Columns.Count-1; i++) { pvtqry += row[i].ToString(); } } pvtqry = pvtqry.Substring(0, pvtqry.Length - 1); pvtqry = "select column2, " + pvtqry + " from level_zero group by column2 order by column2"; sconn.Open(); sqlcmd = new SqlCommand(pvtqry, sconn); sqlcmd.CommandType = CommandType.Text; pvtdr = sqlcmd.ExecuteReader(CommandBehavior.CloseConnection); DataTable pvttable = new DataTable(); pvttable.Load(pvtdr); PivotGrid.DataSource = pvttable; PivotGrid.DataBind();
The above query returns 1024 columns with 400 rows which takes about 6 to 7 minutes to bind the datas to radgrid. The query is getting executed in 8 secs, but binding it to the grid takes time. Since the query building is dynamic, there are possiblities to have more columns binded. Can some one suggest me in binding the records faster.
Thanks in advance.
Sangeetha
aspx:<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="Default.aspx.vb" Inherits="WebApplication1._Default" %><%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title></title></head><body> <form id="form1" runat="server"> <div> <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> </telerik:RadScriptManager> <telerik:RadGrid ID="RadGrid1" runat="server" AllowPaging="True" AutoGenerateColumns="true" PagerStyle-AlwaysVisible="true" GridLines="None" PageSize="8" SelectedItemStyle-BackColor="#ffff99" Skin="Web20"> <PagerStyle Mode="NextPrevAndNumeric" PageButtonCount="8" /> <ClientSettings> <Selecting AllowRowSelect="True" /> </ClientSettings> </telerik:RadGrid> </div> </form></body></html>vb:Imports System.DataImports System.Data.SqlClientPartial Public Class _Default Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Try Dim cn As New SqlConnection("Data Source =(local);Initial Catalog = test;User id = sa;Password = test@123") Dim da As New SqlDataAdapter("select * from t", cn) Dim ds As New DataSet da.Fill(ds, "dt") RadGrid1.DataSource = ds.Tables(0) Catch ex As Exception End Try End SubEnd ClassThis is the problem I'm having:
I have
<
telerik:RadSplitter
<telerik:RadPane
<telerik:RadTabStrip
The Tabstrip is connected to MultiPage.
One of the pages has RadTreeVew with its content being populated dynamically.
When I expand the tree nodes to the point the their height exceeds the height of the panel the scroll bar apprears but when I scroll it the tabs scroll alone with it.
I believe the tabs should stay in their position.
I believe the scroll bar belongs to the panel on which the Tree is located but I believe that the TreeView's scroll bar should be displayed.
<%
@ Control Language="C#" AutoEventWireup="true" CodeFile="ContentPanel.ascx.cs" Inherits="ContentPanel" %>
<%
@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>
<
telerik:RadSplitter ID="RadSplitter1" Runat="server" Width="100%"
Skin="Vista">
<telerik:RadPane ID="RadPane1" Runat="server" width="30%" Scrolling="Both">
<telerik:RadTabStrip ID="TOCTab" runat="server" SelectedIndex="3" MultiPageID="MultiPageProjects"
Skin="Web20" PerTabScrolling="True" ScrollChildren="True">
<tabs>
<telerik:RadTab runat="server" Text="TOC" ScrollChildren="true">
</telerik:RadTab>
<telerik:RadTab runat="server" Text="Figures">
</telerik:RadTab>
<telerik:RadTab runat="server" Text="Tables">
</telerik:RadTab>
<telerik:RadTab runat="server" Text="Search" Selected="True">
</telerik:RadTab>
</tabs>
</telerik:RadTabStrip>
<telerik:RadMultiPage ID="MultiPageProjects" runat="server" SelectedIndex="3"
CssClass="multiPage" ScrollBars="Auto">
<telerik:RadPageView ID="PageViewTOC" runat="server" Width="100%"
Selected="True">
<telerik:RadTreeView ID="TOCTree" Runat="server" Skin="Hay">
</telerik:RadTreeView>
</telerik:RadPageView>
<telerik:RadPageView ID="PageViewExchanges" runat="server"
CssClass="pageViewEducation" Width="100%" Height="100%">
</telerik:RadPageView>
<telerik:RadPageView ID="RadPageView3" runat="server">
</telerik:RadPageView>
<telerik:RadPageView ID="RadPageView4" runat="server" Width="100%"
Height="100%">
</telerik:RadPageView>
</telerik:RadMultiPage>
</
telerik:RadPane>
<telerik:RadSplitBar ID="RadSplitBar1" runat="server">
</telerik:RadSplitBar>
<telerik:RadPane ID="RadPane2" Runat="server">
second pane
</telerik:RadPane>
</telerik:RadSplitter>