Hi
i have database update problems with two related listboxes , the errors appear when i try to move an item from the first listbox to the second (it seems like the fields value is not transferred with the item) or when i try to delete an item from the second listbox (scalar variable isn't declared error)!
Got a problem also with my ajaxpanel it dosent seem to work (the page reloads when i try to move an item)
i would liked to attach my project but it says File is not of correct type so here is the aspxpage code !
i have database update problems with two related listboxes , the errors appear when i try to move an item from the first listbox to the second (it seems like the fields value is not transferred with the item) or when i try to delete an item from the second listbox (scalar variable isn't declared error)!
Got a problem also with my ajaxpanel it dosent seem to work (the page reloads when i try to move an item)
i would liked to attach my project but it says File is not of correct type so here is the aspxpage code !
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication3._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"> <telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" height="200px" width="737px" HorizontalAlign="NotSet" LoadingPanelID="RadAjaxLoadingPanel1" RenderMode="Inline"> <div style="float:left; margin-left:20px"> <telerik:RadListBox runat="server" ID="RadListBox1" DataSourceID="SqlDataSource1" DataKeyField="mail" DataTextField="mail" DataSortField="mail" Height="200px" AllowTransfer="True" TransferToID="RadListBox2" AutoPostBackOnTransfer="True" DataValueField="mail" style="top: 0px; left: 0px; width: 222px" AllowAutomaticUpdates="True" TransferMode="Copy" /> </div> <div style="float:left; margin-left:20px;"> <telerik:RadListBox runat="server" ID="RadListBox2" DataSourceID="SqlDataSource2" DataKeyField="mail" DataTextField="mail" DataSortField="SortOrder" Width="230px" Height="200px" AllowReorder="True" AutoPostBackOnReorder="True" AllowDelete="True" AutoPostBackOnDelete="True" AllowAutomaticUpdates="True" DataValueField="mail" TransferToID="RadListBox1" /> </div> </telerik:RadAjaxPanel> <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" Runat="server" Skin="Default"> </telerik:RadAjaxLoadingPanel> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:notifications_dbConnectionString %>" DeleteCommand="DELETE FROM [utilisateurs] WHERE [mail] = @mail" InsertCommand="INSERT INTO [utilisateurs] ([mail]) VALUES (@mail)" SelectCommand="SELECT [mail] FROM [utilisateurs]"> <DeleteParameters> <asp:Parameter Name="mail" Type="String" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="mail" Type="String" /> </InsertParameters> </asp:SqlDataSource> <telerik:RadScriptManager ID="RadScriptManager1" Runat="server"> </telerik:RadScriptManager> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:notifications_dbConnectionString %>" DeleteCommand="DELETE FROM [presents] WHERE [mail] = @mail AND [id_plan] = @id_plan" InsertCommand="INSERT INTO [presents] ([mail], [id_plan]) VALUES (@mail, @id_plan)" SelectCommand="SELECT [mail], [id_plan] FROM [presents]"> <DeleteParameters> <asp:Parameter Name="mail" Type="String" /> <asp:Parameter Name="id_plan" Type="Int32" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="mail" Type="String"/> <%--in my project the id_plan key is transferred with a link but you can do the same by adding to the current page adresse in the browser " ?id_plan=key" key could be 2 or 1 here --%> <asp:QueryStringParameter DefaultValue="2" Name="id_plan" QueryStringField="id_plan" Type="Int32" /> </InsertParameters> </asp:SqlDataSource> </form></body></html>