I am working for the first time with the radgrid drag and drop feature; I believe I do have it working properly as I can view the row count growing as I drop new items. However, my grid does not reflect this. My code is below. PLEASE HELP!
Imports System.Data Partial Class Sales_SalesPresentationGenerator Inherits System.Web.UI.Page Dim ds As New DataSet Dim TitleName As DataColumn = New DataColumn("Title", Type.GetType("System.String")) Dim TitleID As DataColumn = New DataColumn("TitleID", Type.GetType("System.Int32")) Dim Territory As DataColumn = New DataColumn("Territory", Type.GetType("System.String")) Dim TerritoryID As DataColumn = New DataColumn("TerritoryID", Type.GetType("System.Int32")) Dim Medium As DataColumn = New DataColumn("Medium", Type.GetType("System.String")) Dim MediumID As DataColumn = New DataColumn("MediumID", Type.GetType("System.Int32")) Private Property dt As DataTable Get Return ViewState("dt") End Get Set(value As DataTable) ViewState("dt") = value End Set End Property Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load If Not IsPostBack Then dt = New DataTable() dt.Columns.Add(TitleID) dt.Columns.Add(TitleName) dt.Columns.Add(TerritoryID) dt.Columns.Add(Territory) dt.Columns.Add(MediumID) dt.Columns.Add(Medium) SelectedGrid.DataSource = dt SelectedGrid.DataBind() End If End Sub 'Add to selected Protected Sub TitlesGrid_RowDrop(sender As Object, e As Telerik.Web.UI.GridDragDropEventArgs) Handles TitlesGrid.RowDrop 'e.DraggedItems.Count For Each r In e.DraggedItems Dim temp As DataRow temp = dt.NewRow() temp.Item("TitleID") = CType(CType(r.Item("TitleID"), TableCell).Text, Integer) temp.Item("Title") = CType(r.Item("Title"), TableCell).Text temp.Item("Medium") = CType(r.Item("Medium"), TableCell).Text temp.Item("MediumID") = CType(CType(r.Item("MediumID"), TableCell).Text, Integer) temp.Item("Territory") = CType(r.Item("Territory"), TableCell).Text temp.Item("TerritoryID") = CType(CType(r.Item("TerritoryID"), TableCell).Text, Integer) dt.Rows.Add(temp) ' MsgBox(dt.Rows.Count) Next SelectedGrid.Rebind() End Sub 'Remove from Selected Protected Sub SelectedRowDrop(sender As Object, e As Telerik.Web.UI.GridDragDropEventArgs) Handles SelectedGrid.RowDrop End Sub End Class
<%@ Page Title="" Language="VB" MasterPageFile="~/All/Site.master" AutoEventWireup="false" CodeFile="SalesPresentationGenerator.aspx.vb" Inherits="Sales_SalesPresentationGenerator" %> <%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %> <asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server"> </asp:Content> <asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server"> <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> </telerik:RadScriptManager> <telerik:RadFilter ID="RadFilter1" runat="server" CssClass="RadFilter RadFilter_Default RadFilter RadFilter_Default RadFilter RadFilter_Default " FilterContainerID="TitlesGrid" Skin="Vista"> </telerik:RadFilter> <div style="width:48%; float:left"> <telerik:RadGrid ID="TitlesGrid" runat="server" AllowPaging="True" AllowSorting="True" DataSourceID="TitlesDataSource" GridLines="None" ShowGroupPanel="True" Skin="Vista" AllowMultiRowSelection="True"> <ClientSettings AllowDragToGroup="True" AllowRowsDragDrop="True"> <Selecting AllowRowSelect="True" /> </ClientSettings> <MasterTableView AutoGenerateColumns="False" DataSourceID="TitlesDataSource"> <CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings> <RowIndicatorColumn> <HeaderStyle Width="20px"></HeaderStyle> </RowIndicatorColumn> <ExpandCollapseColumn> <HeaderStyle Width="20px"></HeaderStyle> </ExpandCollapseColumn> <Columns> <telerik:GridBoundColumn DataField="Title" HeaderText="Title" SortExpression="Title" UniqueName="Title"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="TitleID" HeaderText="TitleID" SortExpression="TitleID" UniqueName="TitleID" Visible="False" DataType="System.Int32"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Synopsis" HeaderText="Synopsis" SortExpression="Synopsis" UniqueName="Synopsis" Visible="False"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Genre" HeaderText="Genre" SortExpression="Genre" UniqueName="Genre"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Territory" HeaderText="Territory" SortExpression="Territory" UniqueName="Territory"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="TerritoryID" DataType="System.Int32" HeaderText="TerritoryID" SortExpression="TerritoryID" UniqueName="TerritoryID" Visible="False"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Medium" HeaderText="Medium" SortExpression="Medium" UniqueName="Medium"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="MediumID" DataType="System.Int32" HeaderText="MediumID" SortExpression="MediumID" UniqueName="MediumID" Visible="False"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="AvailDate" DataType="System.DateTime" HeaderText="AvailDate" SortExpression="AvailDate" UniqueName="AvailDate"> </telerik:GridBoundColumn> </Columns> </MasterTableView> <HeaderContextMenu EnableImageSprites="True" CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu> </telerik:RadGrid> <asp:AccessDataSource ID="TitlesDataSource" runat="server" DataFile="~/App_Data/PDF GENERATOR DATA.accdb" SelectCommand="SELECT * FROM [Avails]"></asp:AccessDataSource> <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" Runat="server" InitialDelayTime="5" MinDisplayTime="5" Skin="Default" Transparency="20"> </telerik:RadAjaxLoadingPanel> <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" DefaultLoadingPanelID="RadAjaxLoadingPanel1"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="SelectedGrid"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="SelectedGrid" /> <telerik:AjaxUpdatedControl ControlID="TitlesGrid" /> </UpdatedControls> </telerik:AjaxSetting> <telerik:AjaxSetting AjaxControlID="TitlesGrid"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="SelectedGrid" /> <telerik:AjaxUpdatedControl ControlID="TitlesGrid" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> </div> <div style="width:48%; float:left"> <telerik:RadGrid ID="SelectedGrid" runat="server" Skin="Vista" AllowMultiRowSelection="True"> <ClientSettings AllowRowsDragDrop="True"> <Selecting AllowRowSelect="True" /> </ClientSettings> <MasterTableView> <CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings> <RowIndicatorColumn> <HeaderStyle Width="20px"></HeaderStyle> </RowIndicatorColumn> <ExpandCollapseColumn> <HeaderStyle Width="20px"></HeaderStyle> </ExpandCollapseColumn> </MasterTableView> <HeaderContextMenu EnableImageSprites="True" CssClass="GridContextMenu GridContextMenu_Vista"></HeaderContextMenu> </telerik:RadGrid> </div> </asp:Content>