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
>