<frameset border="0" rows="75,*,10" id="0"> <frame name="contentmenu" src="<%=menuUrl%>" scrolling="no" noresize="noresize" frameborder="0" /> <frameset border="0" cols="284,*" frameborder="0" framespacing="0" runat="server" id="colsFrameset" enableviewstate="false"> <frame name="contenttree" src="ContentMenu.aspx" scrolling="no" frameborder="0" framespacing="0" border="0" runat="server" id="frameTree" class="TreeFrame" /> <frame name="contentview" src="../UnderConstruction.aspx" frameborder="0" border="0" framespacing="0" runat="server" id="frameView" /> </frameset> <frame name="contentfooter" src="footer.aspx" scrolling="no" noresize="noresize" frameborder="0" /> <noframes> <p id="p1"> This HTML frameset displays multiple Web pages. To view this frameset, use a Web browser that supports HTML 4.0 and later. </p> </noframes> </frameset><script type="text/javascript">
//<![CDATA[
function LoadItem(elementName, elementUrl) {
parent.frames['contentview'].location.href = elementUrl;
}
//]]>
</script>
<telerik:RadTreeView ID="RadTreeView1" runat="server" CausesValidation="false " OnNodeClick="RadTreeView1_NodeClick" OnContextMenuItemClick="RadTreeView1_ContextMenuItemClick"> <ContextMenus> <telerik:RadTreeViewContextMenu ID="RadTreeViewContextMenu1" runat="server"> <Items> <telerik:RadMenuItem runat="server" Text="Add New Page" PostBack="true"> </telerik:RadMenuItem> <telerik:RadMenuItem runat="server" Text="Remove" PostBack="true"> </telerik:RadMenuItem> </Items> </telerik:RadTreeViewContextMenu> </ContextMenus> <DataBindings> <telerik:RadTreeNodeBinding Expanded="true" /> </DataBindings> </telerik:RadTreeView>protected void RadTreeView1_NodeClick(object sender, RadTreeNodeEventArgs e) { this.NodeText = e.Node.Value; }protected void RadTreeView1_ContextMenuItemClick(object sender, RadTreeViewContextMenuEventArgs e) { if (e.MenuItem.Text == "Add New Page") { //radpanel1.Visible = true; //txtTile.Text = this.NodeText; e.MenuItem.NavigateUrl = "http://www.google.com"; e.MenuItem.Target = "contentview"; } else if (e.MenuItem.Text == "Remove") { RadTreeView1.SelectedNode.Remove(); } }<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="GridButtonIndex.aspx.cs" Inherits="TestTelerikWebApp.GridButtonIndex" %> <!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"> <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> </telerik:RadScriptManager> <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server"> <script type="text/javascript"> function OnGridCommand(sender, args) { var grid = sender; debugger; if (args.get_commandName() == "InitInsert" && grid._editIndexes[0] >= 0) { alert("Cannot add while editing a record."); args.set_cancel(true); } if (args.get_commandName() == "Delete") { if (grid._editIndexes[0] >= 0) { alert("Cannot delete while editing a record."); args.set_cancel(true); } else var value = confirm("Are you sure you want to delete?"); if (!value) args.set_cancel(true); } } </script> </telerik:RadCodeBlock> <div> <telerik:RadGrid ID="dgTest" runat="server" AutoGenerateColumns="False" GridLines="None" OnItemCommand="dgTest_ItemCommand" OnNeedDataSource="dgTest_NeedDataSource"> <ClientSettings> <ClientEvents OnCommand="OnGridCommand" /> </ClientSettings> <MasterTableView> <CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings> <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column"> <HeaderStyle Width="20px"></HeaderStyle> </RowIndicatorColumn> <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column"> <HeaderStyle Width="20px"></HeaderStyle> </ExpandCollapseColumn> <Columns> <telerik:GridBoundColumn DataField="Description" FilterControlAltText="Filter colDesc column" HeaderText="Description" UniqueName="colDesc"> </telerik:GridBoundColumn> <telerik:GridButtonColumn ButtonType="PushButton" CommandName="TestClick" FilterControlAltText="Filter colButt column" Text="Press Me" UniqueName="colButt"> </telerik:GridButtonColumn> </Columns> <EditFormSettings> <EditColumn FilterControlAltText="Filter EditCommandColumn column"> </EditColumn> </EditFormSettings> </MasterTableView> <FilterMenu EnableImageSprites="False"> </FilterMenu> <HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"> </HeaderContextMenu> </telerik:RadGrid> </div> <asp:Label ID="lblFeedback" runat="server"></asp:Label> <telerik:RadAjaxManager runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="dgTest"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="dgTest" /> <telerik:AjaxUpdatedControl ControlID="lblFeedback" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> </form> </body> </html> using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using Telerik.Web.UI; namespace TestTelerikWebApp { public partial class GridButtonIndex : System.Web.UI.Page { protected DataTable GetData() { DataTable dt = new DataTable(); dt.Columns.Add("Id", typeof(int)); dt.Columns.Add("Description", typeof(string)); DataRow dr = dt.NewRow(); dr["Id"] = 1; dr["Description"] = "Test 1"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["Id"] = 2; dr["Description"] = "Test 2"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["Id"] = 3; dr["Description"] = "Test 3"; dt.Rows.Add(dr); return dt; } protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { } } protected void dgTest_NeedDataSource(object sender, GridNeedDataSourceEventArgs e) { RadGrid rg = (RadGrid)sender; rg.DataSource = GetData(); } protected void dgTest_ItemCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == "TestClick") { GridEditableItem gei = (GridEditableItem)(e.Item); lblFeedback.Text = "Item Index is : " + gei.ItemIndex.ToString(); } } } }<telerik:RadComboBox ID="cboUserDealerAccess" runat="server"
DataSourceID="SqlDataSource6"
DataTextField="LastName"
DataValueField="UserInfoID" />
<asp:SqlDataSource runat="server" ID="SqlDataSource6" ConnectionString="<%$ ConnectionStrings:FT_Data %>"
ProviderName="System.Data.SqlClient" SelectCommand="SELECT [LastName], [UserInfoID] FROM [UserInfo] ORDER By LastName" />
<telerik:RadListBox runat="server" ID="lstLoggedInUserAccess" Height="200px" Width="230px"
AllowTransfer="true" TransferToID="lstSelectedUserAccess" TransferMode="Copy" SelectionMode="Single" DataSourceID="SqlDataSource5" DataTextField="DealerName" DataKeyField="DealerID" DataValueField="DealerID" AutoPostBackOnTransfer="true"/>
<asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:FT_Data %>" ProviderName="System.Data.SqlClient"
SelectCommand="SELECT [DealerID], [DealerName] FROM [Dealer] ORDER By DealerName" OldValuesParameterFormatString="original_{0}" ConflictDetection="CompareAllValues" />
<telerik:RadListBox runat="server" ID="lstSelectedUserAccess" Height="200px" Width="200px"
SelectionMode="Single" DataSourceID="SqlDataSource7" DataKeyField="DealerID" DataTextField="DealerName" DataValueField="DealerID" AllowAutomaticUpdates="true" AllowReorder="false" AllowDelete="True"
AutoPostBackOnDelete="true" AllowTransfer="false"/>
<asp:SqlDataSource ID="SqlDataSource7" runat="server" ConnectionString="<%$ ConnectionStrings:FT_Data %>" ProviderName="System.Data.SqlClient"
SelectCommand="SELECT [Dealer].[DealerID], [Dealer].[DealerName] FROM [UserDealer] INNER JOIN [Dealer] ON [UserDealer].[DealerId] = [Dealer].[DealerID] WHERE ([UserDealer].[UserInfoId] = @UserInfoID)"
InsertCommand="INSERT INTO [UserDealer] ([UserInfoID], [DealerID]) VALUES (@UserInfoID, @DealerID)"
DeleteCommand="DELETE FROM [UserDealer] WHERE (UserInfoId = @UserInfoID and DealerId = @DealerID)"
OldValuesParameterFormatString="original_{0}" ConflictDetection="CompareAllValues" >
<DeleteParameters>
<asp:ControlParameter Name="DealerID" Type="Int32" ControlID="lstSelectedUserAccess" PropertyName="SelectedValue" /> <asp:ControlParameter Name="UserInfoID" DbType="Int32" ControlID="cboUserDealerAccess" PropertyName="SelectedValue"/>
</DeleteParameters>
<InsertParameters>
<asp:ControlParameter Name="DealerID" Type="Int32" ControlID="lstLoggedInUserAccess" PropertyName="SelectedValue" />
<asp:ControlParameter Name="UserInfoID" DbType="Int32" ControlID="cboUserDealerAccess" PropertyName="SelectedValue"/>
</InsertParameters>
<SelectParameters>
<asp:ControlParameter Name="UserInfoID" DbType="Int32" ControlID="cboUserDealerAccess" PropertyName="SelectedValue"/>
</SelectParameters>
</asp:SqlDataSource>
When I change the INSERT parameter to this (see below) then it comes back empty and gives an error "Cannot Insert a Null..."
<asp:Parameter Name="DealerID" Type="Int32"/>