.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

How do I get the last date if selected does not exist?

Posted By:      Posted Date: October 24, 2010    Points: 0   Category :ASP.Net
 

Hi All,

My table

Date, Currency
10.10.2010 EUR
19.10.2010 USD
20.19.2010, EUR
21.10.2010, USD

If I have a date 9.10.2010, choose the nearst date 10.10.2010 EUR

If I have a date 18.10.2010 (this date does not exist), choose the nearest date 19.10.2010

If I have a date 25.10.2010, choose 21.10.2010 USD


How can you help me?

Regards,
Dejan




View Complete Post


More Related Resource Links

List does not exist The page you selected contains a list that does not exist. It may have been de

  
Hello All,   We are facing an error in our MOSS 2007 internet site.   We are unable to access the root site ,however all other site collections created using manged path under the root site are accessible.   The home page of the root site i.e http://servername/pages/default.aspx  navigates to custom error page , where as application pages like settings.aspx ,viewlsts.aspx throw below mentioned error   "List does not exist  The page you selected contains a list that does not exist.  It may have been deleted by another user" As a workaround , we tried restoring the rootsite from back up file (.dat) ,but we get the same error (mentioned above).   Content database is very much present and database server has good enough memory.   Any suggestions for this would be of great help.  

"List does not exist The page you selected contains a list that does not exist. It may have been del

  
Will you please help me to resolve the following error when I trying to add a new item or edit item in the exist list:- "List does not exist The page you selected contains a list that does not exist. It may have been deleted by another user"

"List does not exist The page you selected contains a list that does not exist. It may have been d

  

Hi all,

In Sharepoint 2010

When I trying to add new item or open an item in the list I see the following error message:

"List does not exist  The page you selected contains a list that does not exist.  It may have been deleted by another user"

Can anybody help me figure out what is causing this error?


Showing Ribbon on master page: The page you selected contains a list that does not exist.

  

I am performing a content database upgrade of a SharePoint 2007 site collection to SharePoint 2010. I used the mount-SPContentDatabase with the –UpdateUserExperience switch. I set the site to use the v4.master page as the master page. If the ribbon is not displayed on the page, the page renders. However when I show the ribbon I get the following error:

 

Server Error in '/' Application.

 


List does not exist.

The page you selected contains a list that does not exist. It may have been deleted by another user.<nativehr>0x81020026</nativehr><nativestack></nativestack>

Validate ASP.net calendar date selected with Javascript?

  

Is there any way I can use javascript to make sure the user has selected a date from my asp.net calendar? I have the calendar under an update panel:

                        <asp:UpdatePanel ID="UpdatePanel2" runat="server">
                            <ContentTemplate>
                                <asp:Calendar ID="Calendar1" runat="server" BackColor="#FFFFCC" BorderColor="Maroon"
                                    BorderWidth="1px" CssClass="calendar" Font-Names="Verdana" Font-Size="9pt" ForeColor="Black"
                                    Height="200px" Width="305px" DayNameFormat="Shortest" ShowGridLines="False">
                                    <SelectedDayStyle BackColor="maroon" BorderColor="Black" BorderWidth="1px" Font-Bold="true" Font-Size="11pt" />
                                    <SelectorStyle BackColor="#FFCC66" />
                                    <TodayDayStyle Font-Bold="true" Font-Size="16pt"/>
                                    <OtherMonthDayStyle ForeColor="#CC9966" />
                                    &

select record based on / match selected date

  
 
with the sql statement below, i try to select the records based on the selected date, it return no rows from adapter filled datatable. 
however, when i run the query in sql query in sql server studio management, it returns records. 
date format = 09/28/2010

string[] splitDT = txtSelectedDate.Text.Split('/');

            string strRearrangeDT = splitDT[0] + "/" + splitDT[1] + "/" + splitDT[2];

using (SqlConnection sqlconn = new SqlConnection(connstring))
            {
                DataTable dt = new DataTable();
                string strSQL = "SELECT userclaim_details3.id, userclaim_details3.userclaimid, userclaim_details3.userid, userclaim_details3.childcategorytableid, userclaim_details3.statusid, " +
                         "userclaim_details3.amount AS amountname, userclaim_details3.remark AS remarkname, userclaim_details3.datecreated AS datecreatedname, " +
                         "userclaim_details3.datemodified, approvaltable.id AS Expr1, approvaltable.typename AS statusname, usertable2.id AS Expr2, usertable2.name AS uname, " +
                         "childcategorytable.id AS Expr3, childcategorytable.categor

List does not exist / The page you selected contains a list that does not exist. It may have been de

  

This error pops up on all workspace sites; ie. Site Pages --> Add new page

List does not exist.

The page you selected contains a list that does not exist.  It may have been deleted by another user.

Troubleshoot issues with Microsoft SharePoint Foundation.

Correlation ID: 0a9233af-9c1e-4d27-91cb-b0a58b7f3419

Date and Time: 10/8/2010 1:20:06 PM


Calcuate duration between selected date(Filter)

  

Hi,

I'm trying to calcucate duration between 2 date sets using paramters.

1. I do have a stored procedure with 2 filter sets. End date and duration.

2. Created SSRS report with 2 filter sets.  End Date and Duration. It worked fine.

3. Customer wants to use Start date and End Date as filter. (I cannot modify stored procedure)

4. I created a dummy parameter for Start Date.

5. Duration default expression as

=DateDiff("d",parameters!StartDate.Value,parameters!EndDate.Value)

6. This works as I expected but when they change any date or other parameters, duration calculation does NOT update.

 

Why it is not updated?

 

Thanks


SoyLover

returning a date with a count of zero if it doesn't exist in the date range?

  

i have the following query.

SELECT DATEADD(dd,0, DATEDIFF(dd,0,accesseddate)) AS hitdate, COUNT(hitid) AS hitsperday
FROM hits h
INNER JOIN url u
ON h.urlid = u.urlid
WHERE (accesseddate BETWEEN DATEADD(d, -6, GETDATE()) AND GETDATE() AND u.userid = @userid)
GROUP BY DATEADD(dd,0, DATEDIFF(dd,0,accesseddate))
ORDER BY hitdate DESC

but if there were no "hits" for a particular date range in the last week i only get the dates returned where there were hits. i need to get all the days returned and where there were no results, i need a zero returned.

hitdate            hitsperday

2010-10-07     2
2010-10-06     58
2010-10-04     1645
2010-10-03     1192 


what i need to return is this:     

hitdate                 hitsperday

2010-10-08     0
2010-10-07     2
2010-10-06     58
2010-10-05     0
2010-10-04     1645
2010-10-03     1192

any suggestions?

thank you very much.

MDX - Find last leaf member of Date dimension under selected member of Date dimension, independently

  

Hi all

I need to reproduce the behaviour of the averageofchildren function with the exception that the function should always build the average of all members (even when the value of a member equals null). As you know average of children function always build the average at the lowest level of the time dimension.

My date dimension looks like the following:

[Date].[Fiscal] user defined hierarchy:

-Year

-Period

-Week

if context of [Date].[Fiscal].CurrentMember corresponds to a Week, I can retrieve all weeks before the current week using

In Period: MTD([Date].[Fiscal].CurrentMember)  -- PeriodsToDate also works fine

In Year: YTD([Date].[Fiscal].CurrentMember)

if context of [Date].[Fiscal].CurrentMember corresponds to a Period

How can I get all weeks (NOT Periods!) contained in all Periods before and within current period since start of year?

What would be a generic expression that retrieves all weeks before and in independently of level of selected Date dimension member

Thanks

 

 


SharePoint DateTime control returning current date when no date is selected

  
Hi,
 
In WSS 3.0, I am using sharePoint DateTime control. I retrieve the date selected by the user using SelectedDate property of the sharePoint DateTime control.

The issue is that even when the user has not selected any date in the sharePoint DateTime control, the SelectedDate property of the sharePoint DateTime control returns current date. I guess it should return DateTime.MinValue or null when the user has not selected any date in the sharePoint DateTime control.

Kindly clarify.

Thanks,
Bala

show selected date in calendar

  

Hi all,

I've got this terrible brain freeze today ;-)

I have an asp:Calendar (not ajax). When I set the selectedDate from codebehind to a date in another month, I'd want the new selected date to show (that is, show the calendar "page" with the new month. How do I do this?

calFromDate.SelectedDate = myDate 'works fine

calFromDate.ShowSelectedDate's Month 'pseudocode

 

The calendar resides in an updatepanel for speed purposes, but I don't think that has anything to do with anything...

 

Thanks a lot!

/Pettrer


Get selected date value from DropDownList control and pass it to SQL table

  

Hi,

This must be something not very difficult but I am pretty new in C# and have a problem to resolve.

I have tree dropdownlist controls. One of the control values are dates. When client selects all three drop downs then I am passing values to SQL table. Everything works but one. Date value shows 1900-01-01 instead of selected value in SQL table. I am not passing date value correctly but can't figure out how to do it.

Following is a code:

<td>
                            <asp:DropDownList ID="ddlLocation" runat="server" AutoPostBack="True" 
                                DataSourceID="SqlDataSource3" DataTextField="ShowLocation" 
                                DataValueField="ShowLocation">
                                                            </asp:DropDownList>
                            <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
                                ConnectionString="<%$ ConnectionStrings:myconnection%>" 
                                SelectCommand="SELECT * FROM [ShowLocation]"></asp:SqlDataSource>
                        </td>
                        <td>
                            Location</td>
          

Problem in setting calendar selected date

  

I am using the fallowing code to set the selected date of calendar control to one day previous of the current date, but still the calendar is showing the current date as the selected date.

Calendar1.SelectedDate =

DateTime.Now.AddDays(-1);

can anyone help me regarding this issue.


Newbie Question: How to sum a selected date and previous dates

  

I'm trying to get an employee count based upon the user selecting a given date in my date dimension.  My fact table contains a list of all employees that are 'Active', and my date dimension (Query Date) is joined to 'Hire_Date' in my fact table.  My dilemna is that if a user selects a given date, it only returns the employees who were hired on that date.  What I would like to do is create a calculated member that will show all employees hired on that date + those hired before that date.  Can anybody help me with this...I would appreciate it in advance...

Kole


KRS

"List Does not Exist, the page you selected contains a list that does not exist. It may have been de

  
Hello Folks,
One the User is getting "List Does not Exist, the page you selected contains a list tha does not exist. It may have been deleted by another user." Error while User open Subsite Directly.
This Subsite has a list displayed on home page.
I have checked user is added in to Site Member group which has Contribute Permission and List is inheriting this group.
any help will be appreciated.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend