How do I break the link?

Jul 22, 2007 at 7:19 PM
I have created a new folder and pages for a XXXX page by copying the News folder and pages.
Converted all News references to XXXX.
Created a tables ( DownloadsInXXXX ) & Stored Procedures (DownloadsByXXXX) Converted all News references to XXXX.
Everything works like it is suppose to, but When you post in XXXX it also post in News.
How do I break the link?
Jul 24, 2007 at 12:29 AM
Edited Jul 24, 2007 at 2:07 AM
After making the changes above post, I created Stored Procedures for Dardanelle that is copy of Announcements,News and all the Tables.

I have this code in Dardanelle/list.aspx page.

12. Protected Sub SqlDataSource1_Selected(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceStatusEventArgs)
13. Dim pages As Integer

14. pages = CInt(e.Command.Parameters("@pageCount").Value)

15. Pn2.Count = pages
16. End Sub

The error below refers to line 14 above

System.InvalidCastException was unhandled by user code
Message="Conversion from type 'DBNull' to type 'Integer' is not valid."
Source="Microsoft.VisualBasic"
StackTrace:
at Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(Object Value)
at ASP.dardanellelistaspx.SqlDataSource1_Selected(Object sender, SqlDataSourceStatusEventArgs e) in C:\Documents and Settings\Owner\My Documents\Test Web site\Dardanelle\List.aspx:line 14
at System.Web.UI.WebControls.SqlDataSourceView.OnSelected(SqlDataSourceStatusEventArgs e)
at System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments)
at System.Web.UI.WebControls.Repeater.GetData()
at System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource)
at System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e)
at System.Web.UI.WebControls.Repeater.DataBind()
at System.Web.UI.WebControls.Repeater.EnsureDataBound()
at System.Web.UI.WebControls.Repeater.OnPreRender(EventArgs e)
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


Any ideals on how to correct this?
Jul 28, 2007 at 7:34 AM
Well I have made progress with my converted News folder, pages, Tables and Stored Procedures.
Ran new SqlDataSource query to connect
Now I can open the new pages and click on the add new Article button and it opens but when I click save
It shows no Article posted?
At a lost.
Coordinator
Jul 28, 2007 at 4:46 PM
On what page does the article not show up on?

If you are on the list view, look at "Recent Events". It might have been put down there.
Jul 30, 2007 at 8:39 PM
It does not show up on any page.
Coordinator
Jul 30, 2007 at 10:37 PM
Is it broken in v3?
Jul 31, 2007 at 5:38 AM
Edited Aug 1, 2007 at 2:43 AM
No ClubStarterKit 2 Final

When I click on Dardanelle link, the /Dardanelle/list.aspx opens.
When I click on New Article: the /Dardanelle/Edit.aspx opens.
When I click on Save Article: the /Dardanelle/list.aspx opens, but there is no Article posted
Aug 1, 2007 at 4:55 AM
You need to walk through the process in debug. What I've found is that errors aren't really being trapped effectively in all cases. I'm sure you'll figure out why the record isn't being added to the database in debug mode...
Aug 1, 2007 at 7:23 AM
Edited Aug 1, 2007 at 7:35 AM
I don't know if this is what you are referring to, but I hit the save button (There was no post.) when I click Log off Button I got this error.
Line 38 is the same as News/edit.aspx line 38.


System.NullReferenceException was unhandled by user code
Message="Object reference not set to an instance of an object."
Source="AppWeb_mfpr4ae"
StackTrace:
at ASP.dardanelleeditaspx.FormView1_DataBound(Object sender, EventArgs e) in C:\Documents and Settings\Owner\My Documents\Test Web site\Dardanelle\Edit.aspx:line 38
at System.Web.UI.WebControls.BaseDataBoundControl.OnDataBound(EventArgs e)
at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data)
at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)
at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
at System.Web.UI.WebControls.FormView.DataBind()
at System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound()
at System.Web.UI.WebControls.FormView.EnsureDataBound()
at System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls()
at System.Web.UI.Control.EnsureChildControls()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Coordinator
Aug 1, 2007 at 1:18 PM
In v3 beta 1 I took out the stored proc and it now runs from the business logic. This is (should be...) fixed in v3 beta 1.
Aug 1, 2007 at 8:56 PM
For learning purposes how can I fix this error?
Coordinator
Aug 1, 2007 at 10:36 PM
:) No clue.