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.Data
Imports System.Data.SqlClient
Partial 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 Sub
End Class
This 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>
Protected
Sub
Menu_ItemDataBound(
ByVal
sender
As
Object
,
ByVal
e
As
Telerik.Web.UI.RadMenuEventArgs)
Handles
Menu.ItemDataBound
Dim
menuItem =
DirectCast
(e.Item.DataItem, dsAdmin.MenuItemRow)
If
menuItem.MenuItemType =
"Separator"
Then
e.Item.IsSeparator =
True
End
If
End
Sub
ChartAxisItem xItem = RadChartRiding.PlotArea.XAxis[i];
xItem.TextBlock.Text =
string
.Format(
"{2}{0}\n{1}"
, r[
"firstName"
], r[
"lastName"
], (i == d.Rows.Count - 1 ?
" - LEADER -\n"
:
""
));
xItem.TextBlock.Appearance.FillStyle.FillType = Telerik.Charting.Styles.FillType.Image;
xItem.TextBlock.Appearance.FillStyle.FillSettings.BackgroundImage =
string
.Format(
"images/elections/{0}Icon.png"
, barCode[i]);
xItem.TextBlock.Appearance.Dimensions.AutoSize =
false
;
xItem.TextBlock.Appearance.FillStyle.FillSettings.ImageDrawMode = Telerik.Charting.Styles.ImageDrawMode.Align;
xItem.TextBlock.Appearance.FillStyle.FillSettings.ImageAlign = Telerik.Charting.Styles.ImageAlignModes.TopLeft;
xItem.TextBlock.Appearance.Position.AlignedPosition = Telerik.Charting.Styles.AlignedPositions.TopRight;
xItem.TextBlock.Appearance.Dimensions.Height = 75;
xItem.TextBlock.Appearance.Dimensions.Width = 330;
xItem.TextBlock.Appearance.Dimensions.Paddings.Top = (i == d.Rows.Count - 1 ? 10 : 20);