LivePersistence is not working for me
Posts
Posts: 167
Joined: 13-Jan-2006
Joined: 13-Jan-2006
I can't seem to get my formview to update my db automatically using LivePersistence set to True. I turned on tracing (level 4) for SqlServerDQE, ORMGeneral, ORMStateManagement and ORMPersistenceExecution and get NO messages from the point when I click the OK button on my form (it is in Edit mode).
I DO get the FormViewInsertEvent (I have a handler for it where I modify the entered data slightly before it is persisted to the db).
I set up things using a mix of declarative code and runtime stuff - maybe I'm doing something wrong there. Also, I have master pages and subclass UI.Pages in the mix 
.net 2.0 designer = v 2.0.0.0 mar 19, 2007 sql server 2005 ORMSupportClasses dll version = 2.0.7.319 DQESQLServer dll version = 2.0.7.129
I'm including 4 snippets of code. The first is the mastpage that my edit forms use, the second is the page (homepage.aspx) that I've been trying to get to work, the third is an ascx that is called up by homepage.aspx (so that I don't have to duplicate markup between the Insert and Update FormView templates), and finally the fourth in the PageLoad method for the homepage.aspx file.
*** 1 Here's the form's Master Page:
<head runat="server">
<link href="~/DefaultAdmin.css" media="screen, print" rel="stylesheet" type="text/css" />
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<uc2:layout1 id="Layout1_1" runat="server" />
<llblgenpro:LLBLGenProDataSource2
ID="LLBLGenProDataSource2_1"
CacheLocation="Session"
LivePersistence="true"
AdapterTypeName="Standards.DatabaseSpecific.DataAccessAdapter, StandardsDBSpecific"
runat="server">
</llblgenpro:LLBLGenProDataSource2>
<asp:FormView ID="FormView1" DataSourceID="LLBLGenProDataSource2_1" DefaultMode="Edit" runat="server">
<InsertItemTemplate>
<asp:contentplaceholder id="ContentPlaceHolder_AddControls" runat="server">
</asp:contentplaceholder>
<asp:Button ID="Button_OK" runat="server" Text="OK" CommandName="Insert" />
<asp:Button ID="Button_Cancel" runat="server" Text="Cancel" UseSubmitBehavior="false" OnClick="Button_Cancel_Click" />
</InsertItemTemplate>
<EditItemTemplate>
<asp:contentplaceholder id="ContentPlaceHolder_EditControls" runat="server">
</asp:contentplaceholder>
<asp:Button ID="Button_OK" runat="server" Text="OK" CommandName="Update" />
<asp:Button ID="Button_Cancel" runat="server" Text="Cancel" UseSubmitBehavior="false" OnClick="Button_Cancel_Click" />
</EditItemTemplate>
</asp:FormView>
</div>
</form>
</body>
</html>
**** 2 The content placeholder contents:
<asp:Content ID="Content_Add" ContentPlaceHolderID="ContentPlaceHolder_AddControls" Runat="Server">
<uc1:homepage_template id="Homepage_template_Insert" runat="server">
</uc1:homepage_template>
</asp:Content>
<asp:Content ID="Content_Edit" ContentPlaceHolderID="ContentPlaceHolder_EditControls" Runat="Server">
<uc1:homepage_template id="Homepage_template_Edit" runat="server">
</uc1:homepage_template>
</asp:Content>
**** 3 the ascx files referenced in **** 2, above:
<div id="header">
<div id="subheader1">
<div id="subheader1_left" style="width:310px;float:left;">
<div style="float:left;">
<asp:Label ID="Label_OrganizationEn" runat="server" Text="Organization Name (En)"></asp:Label>
</div>
<div style="float:right;">
<radI:RadTextBox ID="RadTextBox_OrganizationEn" Text='<%# Bind("NameE") %>' runat="server" />
</div>
</div>
<div id="subheader1_right" style="width:310px;float:left;">
<asp:Label ID="Label_OrganizationFr" runat="server" Text="Organization Name (Fr)"></asp:Label>
<radI:RadTextBox ID="RadTextBox_OrganizationFr" Width="100%" Text='<%# Bind("NameF") %>' runat="server">
</radI:RadTextBox>
</div>
<extRadTS:RadTabStripExtended
id="RadTabstrip_TabbedControls"
MultiPageID="RadMultiPage_TabbedControls"
SelectedIndex="0"
runat="server"
AutoPostBack="true"
OnTabClick="RadTabstrip_TabbedControls_TabClick">
<Tabs>
<radTS:Tab runat="server" Text="About Us"></radTS:Tab>
<radTS:Tab runat="server" Text="Activities"></radTS:Tab>
<radTS:Tab runat="server" Text="Working Groups"></radTS:Tab>
<radTS:Tab runat="server" Text="Documents"></radTS:Tab>
<radTS:Tab runat="server" Text="Bottom"></radTS:Tab>
</Tabs>
</extRadTS:RadTabStripExtended>
<radTS:RadMultiPage ID="RadMultiPage_TabbedControls" SelectedIndex="0" runat="server">
<radTS:PageView ID="PageView_AboutUs" Visible="true" runat="server">
<uc1:homepage_aboutus
ID="Homepage_aboutus1"
runat="server"
EntityFieldNameEn="AboutUsE"
EntityFieldNameFr="AboutUsF" />
</radTS:PageView>
<radTS:PageView ID="PageView_Activities" Visible="false" runat="server">
<uc2:homepage_allother
ID="Homepage_allother_Activities"
runat="server"
EntityFieldNameEn="ActivitiesTextE"
EntityFieldNameFr="ActivitiesTextF"
EntityFieldNameIncludeSection="IncludeActivities"
EntityFieldNameHeadingEn="ActivitiesHeadingE"
EntityFieldNameHeadingFr="ActivitiesHeadingF" />
</radTS:PageView>
<radTS:PageView ID="PageView_WorkingGroups" Visible="false" runat="server">
<uc2:homepage_allother
ID="Homepage_allother_WorkingGroups"
runat="server"
EntityFieldNameEn="GroupTextE"
EntityFieldNameFr="GroupTextF"
EntityFieldNameIncludeSection="IncludeGroups"
EntityFieldNameHeadingEn="GroupsHeadingE"
EntityFieldNameHeadingFr="GroupsHeadingF" />
</radTS:PageView>
<radTS:PageView ID="PageView_Documents" Visible="false" runat="server">
<uc2:homepage_allother
ID="Homepage_allother_Documents"
runat="server"
EntityFieldNameEn="DocumentsE"
EntityFieldNameFr="DocumentsF"
EntityFieldNameIncludeSection="IncludeDraftsIssues"
EntityFieldNameHeadingEn="DraftsIssuesHeadingE"
EntityFieldNameHeadingFr="DraftsIssuesHeadingF" />
</radTS:PageView>
<radTS:PageView ID="PageViewBottom" Visible="false" runat="server">
<uc2:homepage_allother
ID="Homepage_allother_Bottom"
runat="server"
EntityFieldNameEn="BottomE"
EntityFieldNameFr="BottomF"
EntityFieldNameIncludeSection="IncludeBottom"
EntityFieldNameHeadingEn="BottomHeadingE"
EntityFieldNameHeadingFr="BottomHeadingF" />
</radTS:PageView>
</radTS:RadMultiPage>
</div>
</div>
*** 4 Here's the PageLoad for a page that uses the above master page:
protected void Page_Load(object sender, EventArgs e)
{
base.Page_Load(sender, e);
if (!IsPostBack)
{
LLBLGenProDataSource2 dataSource = (LLBLGenProDataSource2)FindControlRecursive.FindControl(Page, "LLBLGenProDataSource2_1");
dataSource.DataContainerType = DataSourceDataContainerType.EntityCollection;
dataSource.EntityFactoryTypeName = "Standards.FactoryClasses.OrganizationEntityFactory, Standards";
FormView formView = (FormView)FindControlRecursive.FindControl(Page, "FormView1");
if (EntityId != 0)
{
formView.ChangeMode(FormViewMode.Edit);
RelationPredicateBucket filter = new RelationPredicateBucket();
filter.PredicateExpression.Add((OrganizationFields.Id == EntityId));
dataSource.FilterToUse = filter;
}
else
{
formView.ChangeMode(FormViewMode.Insert);
}
}
}
Posts: 254
Joined: 16-Nov-2006
Joined: 16-Nov-2006
Posts: 167
Joined: 13-Jan-2006
Joined: 13-Jan-2006
Posts: 167
Joined: 13-Jan-2006
Joined: 13-Jan-2006
Posts: 167
Joined: 13-Jan-2006
Joined: 13-Jan-2006
Posts: 167
Joined: 13-Jan-2006
Joined: 13-Jan-2006
I simplified the code to try to solve this problem and have removed all event handlers.
I did ADD a new event handler just now to try to diagnose the problem - ItemUpdating event handler. I just put a no-op in it that I could break on.
The FormViewItemUpdateEventArgs parameter has an OldValues and NewValues fields which I assume is a collection of the old/new bound field/value pairs. Well, the count of both collections is 0. I think this is wrong but don't know why it isn't working especially since the Update form template does successfully show the field values in the various controls.
Here's the new, simpler code that still doesn't work 
The master.page:
<form id="form1" runat="server">
<div>
<uc2:layout1 id="Layout1_1" runat="server" />
<uc1:MainTabs ID="MainTabs1" runat="server" />
<llblgenpro:LLBLGenProDataSource2
ID="LLBLGenProDataSource2_1"
CacheLocation="Session"
LivePersistence="true"
AdapterTypeName="Standards.DatabaseSpecific.DataAccessAdapter, StandardsDBSpecific"
runat="server">
</llblgenpro:LLBLGenProDataSource2>
<asp:FormView
ID="FormView1"
DataSourceID="LLBLGenProDataSource2_1"
DataKeyNames="Id"
DefaultMode="ReadOnly"
runat="server">
<ItemTemplate>
<div class="ReadControlsWrapper">
<asp:contentplaceholder id="ContentPlaceHolder_ReadControls" runat="server">
</asp:contentplaceholder>
</div>
</ItemTemplate>
<InsertItemTemplate>
<div class="AddControlsWrapper">
<asp:contentplaceholder id="ContentPlaceHolder_AddControls" runat="server">
</asp:contentplaceholder>
<div class="AddEditOKCancel">
<div class="AddEditOK">
<asp:Button ID="Button_OK" CssClass="FloatRight" runat="server" Text="OK" CommandName="Insert" />
</div>
<div class="AddEditCancel">
<asp:Button ID="Button_Cancel" CssClass="FloatLeft" runat="server" Text="Cancel" UseSubmitBehavior="false" OnClick="Button_Cancel_Click" />
</div>
</div>
</div>
</InsertItemTemplate>
<EditItemTemplate>
<div class="EditControlsWrapper">
<asp:contentplaceholder id="ContentPlaceHolder_EditControls" runat="server">
</asp:contentplaceholder>
<div class="AddEditOKCancel">
<div class="AddEditOK">
<asp:Button ID="Button_OK" CssClass="FloatRight" runat="server" Text="OK" CommandName="Update" />
</div>
<div class="AddEditCancel">
<asp:Button ID="Button_Cancel" CssClass="FloatLeft" runat="server" Text="Cancel" UseSubmitBehavior="false" OnClick="Button_Cancel_Click" />
</div>
</div>
</div>
</EditItemTemplate>
</asp:FormView>
</div>
</form>
The Update template from homepage.aspx (which uses the master page):
<div class="SubHeader">
<div class="SubHeaderLeft">
<div class="LabelAndTextBox FloatLeft">
<div class="LabelPart FloatLeft">
<asp:Label
ID="Label_OrganizationEn"
runat="server"
Text="Organization Name (En)" />
</div>
<div class="TextBoxPart FloatRight">
<radI:RadTextBox
ID="RadTextBox_OrganizationEn"
Width="100%"
Text='<%# Bind("NameE") %>'
runat="server" />
</div>
</div>
</div>
...etc
LoadPage code from homepage.aspx:
if (!IsPostBack)
{
// Set the NavigateUrl for the Preview based on the currently selected language
// radiobutton on this page and the SPO website app setting in web.config ("WebSiteURI").
// Also uses an AppSetting for the SPO's organization Id ("SPOOrgId").
LLBLGenProDataSource2 dataSource = (LLBLGenProDataSource2)FindControlRecursive.FindControl(Page, "LLBLGenProDataSource2_1");
dataSource.DataContainerType = DataSourceDataContainerType.EntityCollection;
dataSource.EntityFactoryTypeName = "Standards.FactoryClasses.OrganizationEntityFactory, Standards";
RelationPredicateBucket filter = new RelationPredicateBucket();
filter.PredicateExpression.Add((OrganizationFields.Id == Int32.Parse(ConfigurationManager.AppSettings["SPOOrgId"])));
dataSource.FilterToUse = filter;
FormView formView = (FormView)FindControlRecursive.FindControl(Page, "FormView1");
// String[] dataKeys = {"Id"};
// formView.DataKeyNames = dataKeys;
}
}
Posts: 167
Joined: 13-Jan-2006
Joined: 13-Jan-2006
Posts: 167
Joined: 13-Jan-2006
Joined: 13-Jan-2006
Posts: 167
Joined: 13-Jan-2006
Joined: 13-Jan-2006
