
<
telerik:RadMenu ID="FarsiMenu" Runat="server" DataFieldParentID="MenuParentID" dir="rtl"
DataNavigateUrlField="AdminValue" DataSourceID="sdsMenuBuilder"
DataTextField="MenuText" DataValueField="Value" DataFieldID="MenuID" Width="650px"
onprerender="FarsiMenu_PreRender"
style="position:absolute;right:40px;" EnableOverlay="False" AutoScrollMinimumHeight="100" EnableAutoScroll="True">
<DefaultGroupSettings Height="200px" RepeatColumns="1" />
</telerik:RadMenu>
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