Hi.
Please help! How do I disable drag and drop for a single node when the treeview is loaded from a database?
When the database-column "dragdrop" is set to "false" for a node, drag and drop for that node should be disabled.
This is how I load the treeview from the database:
Dim
conn As New SqlConnection("Server=xxx.xxx.xxx.xxx;Database=treeview;User ID=xxxxxx;Password=xxxxxx;Trusted_Connection=False")
Dim query As String = "SELECT * FROM treeview_nodes'"
Dim
adapter As New SqlDataAdapter(query, conn)
Dim
dataTable As New DataTable()
adapter.Fill(dataTable)
nnNO.DataSource = dataTable_nnNO
nnNO.DataFieldID = "id"
nnNO.DataFieldParentID = "parentId"
nnNO.DataTextField = "Text"
nnNO.DataNavigateUrlField = "Href"
nbNO.DataValueField = "value"
nnNO.DataBind()
I assume I must use RadTreeView_NodeDataBound or something... Example code would be great!
Best regards,
Lars Melkevik
We are getting a white space below the grid and only this is because of frozen column not working properly.
<telerik:RadGrid ID="grdCarReservation" runat="server"
AutoGenerateColumns="False" Skin="Office2007" Width="1240px"
OnItemDataBound="grdCarReservation_ItemDataBound" HeaderStyle-Wrap="false"
AllowMultiRowSelection="True">
<ExportSettings ExportOnlyData="True" IgnorePaging="True"
OpenInNewWindow="True">
<Pdf AllowCopy="True" AllowModify="True" PageHeaderMargin="1px"
PageHeight="15in" PageWidth="25in" PaperSize="A4" />
</ExportSettings>
<MasterTableView>
<RowIndicatorColumn>
<HeaderStyle Width="20px" />
</RowIndicatorColumn>
<ExpandCollapseColumn>
<HeaderStyle Width="20px" />
</ExpandCollapseColumn>
<Columns>
<telerik:GridTemplateColumn UniqueName="Select">
<HeaderTemplate>
<asp:CheckBox ID="chkAll" runat="server" AutoPostBack="true"
OnCheckedChanged="chkAll_CheckedChanged" />
</HeaderTemplate>
<ItemTemplate>
<asp:CheckBox ID="chkSelect" runat="server" AutoPostBack="True"
OnCheckedChanged="ToggleRowSelection" />
<asp:HiddenField ID="hdnStockNo" runat="server" Value='<%#Eval("STOCK")%>' />
<asp:HiddenField ID="hdnChassisNo" runat="server"
Value='<%#Eval("CHASSIS")%>' />
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Status" UniqueName="Status">
<ItemTemplate>
<asp:DropDownList ID="ddlResStatus" runat="server" AppendDataBoundItems="true"
Height="20px" Width="80px">
<asp:ListItem Text="--Select--" Value="0"></asp:ListItem>
</asp:DropDownList>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn DataField="CUSTOMER_NAME" HeaderText="Customer Name"
UniqueName="Customer Name">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="CUSTOMER_ID" HeaderText="Customer ID"
UniqueName="Customer ID">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ON_HOLD" HeaderText="On Hold"
UniqueName="On Hold">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="RES" HeaderText="Reserved"
UniqueName="Reserved">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="TEMP" HeaderText="Temp Res"
UniqueName="Temp Res">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="STOCK" HeaderText="Stock No"
UniqueName="Stock No">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="MAKE" HeaderText="Make" UniqueName="Make">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="MODEL" HeaderText="Model"
UniqueName="Model">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="CHASSIS" HeaderText="Chassis No"
UniqueName="Chassis No">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="YOM" HeaderText="YOM" UniqueName="YOM">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="MONTH" HeaderText="Month"
UniqueName="Month">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="REGN DATE" HeaderText="Regn Date"
UniqueName="Regn Date">
</telerik:GridBoundColumn>
<teleik:GridBoundColumn DataField="XMISSION" HeaderText="X'mission"
UniqueName="X'mission">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="CAR TYPE" HeaderText="Car Type"
UniqueName="Car Type">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="COLOUR" HeaderText="Color"
UniqueName="Color">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="PS" HeaderText="PS" UniqueName="PS">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="AC" HeaderText="AC" UniqueName="AC">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="PW" HeaderText="PW" UniqueName="PW">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="DOOR" HeaderText="Door" UniqueName="Door">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="FUEL_TYPE" HeaderText="Engine Type"
UniqueName="Engine Type">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="CC" HeaderText="CC" UniqueName="CC">
</telerik:GridBoundColumn>
</Columns>
</MasterTableView>
<HeaderStyle Wrap="False" />
<ClientSettings AllowColumnsReorder="True" ReorderColumnsOnClient="True">
<Selecting AllowRowSelect="True" />
<Scrolling AllowScroll="True" EnableVirtualScrollPaging="True"
FrozenColumnsCount="3" ScrollHeight="120px" UseStaticHeaders="True" />
<Resizing AllowColumnResize="True" EnableRealTimeResize="True"
ResizeGridOnColumnResize="True" />
</ClientSettings>
</telerik:RadGrid>
this is the code am having.
| protected void Page_Load(object sender, EventArgs e) |
| { |
| RadGrid grid1 = (RadGrid)this.ContentPlaceHolder.FindControl("RadGrid1"); |
| if (grid1 != null) |
| { |
| String recordPerPage = Profile.ApplicationPreferences.RecordsPerPage; |
| Int32 pagesize; |
| bool isNum = Int32.TryParse(recordPerPage, out pagesize); |
| if (isNum) |
| { |
| grid1.PageSize = pagesize; |
| } |
| } |
| } |
For the grid I use the Persister Class.
Now I just short one more thing, and I can't get the hang around it.
I want to save the pagenumber (which page on the pager is active) als to the users profile.
gridSettings[6] = (object)gridInstance?????????? in SaveSetting
and
this.gridInstance.????????= (string)gridSettings[6]
Any pointer will be welcome.
Guss


| <telerik:RadScriptManager ID="radScriptManager" runat="server" /> |
| <asp:UpdatePanel ID="updatePanel" runat="server"/> |
| <asp:ScriptManager ID="scriptManager" runat="server" /> |
| <telerik:RadScriptManager ID="radScriptManager" runat="server" /> |
| <asp:UpdatePanel ID="updatePanel" runat="server"/> |

