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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

checking dates

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :ASP.Net
i'm currently developing a room booking system for college. the problem i had now is to check the selected date against the dates in a table called HOLIDAY. what i have in the HOLIDAY table included: start_date, end_date & event. i'm not using the default system date format as the user require the date to be in dd/mm/yyyy format. so what i did is the conversion which i take in each day, month and year separately and store under different variables. now, what i'm facing is that i cant get the system to check the date accordingly. i need to come out with a formula to cater for the checking of selected date against the start and end date of the holiday. if the selected date doesn't fall under the holiday, i will display the rooms availability to the user. else, error message will be prompt out. is there any suggestion on the formula i can use? what i have is:if (strSelectedDate.Equals(strHolidayStart) == true) { ** error ** } else { if (strSelectedDate.Equals(strHolidayEnd) == true) { ** error ** } else { if (intSelectedYear == intHolidayStartYear && intSelectedYear == intHolidayEndYear) { if (intSelectedMonth == intHolidayStartMonth && intSelectedMonth == intHolidayEndMonth) { if (intSelectedDay > intH

View Complete Post

More Related Resource Links

How to turn off optimistic concurrency checking?


I have run into a problem with optimistic concurrency in my dynamic data application (where all relevant settings are at their default values); when I try to update or delete one of my tables, I see the following error:

 Exception type: ChangeConflictException
 Exception message: Row not found or changed.

I am the only user of my database at the moment, so I can guarantee that the data both exists and has not been changed outside the application!

Various forums have suggested that the way to deal with this is to set the column attributes so that the concurrency checking is disabled; i.e.

[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_PropSurname", DbType="NVarChar(255)", UpdateCheck=UpdateCheck.Never)]

However, to do this manually through the Visual Studio designer will take me hours (I have a lot of tables) and if I then change the schema of one of the tables in the DB, won't I then have to do it all again?  I've tried editing the .designer.cs file directly but my changes are subsequently overwritten (as expected).

All suggestions gratefully received!

Ed Graham

C++ at Work: Web Version Checking, Adding Sound to an App


This month: CWebVersion revisited using HTTP instead of FTP, and adding sounds to an MFC-based app.

Paul DiLascia

MSDN Magazine May 2006

Need function to find difference between two dates


Hi all

I need a function written in vb to find the exact month difference between two dates.

For example

    Start Date : 01/01/2010

    End Date   : 15/02/2010

 then the difference value should be like this 1.5  i.e i need the difference in decimal value.

Checking if a URL Exists


I've got a HttpHandler which outputs XML to the client to play video, it outputs the url to the video, video name etc... Validates the request etc.

However sometimes when i upload new video the main URL doesn't pickup the file from the CDN so i have to use a different URL to go directly to one of the main servers.

For example the CDN url is:
One of the server urls is:

What i want to do is check to see if the file can be reached off the .net url before posting it back to the user.


if http://videos.****.net/ar/ar_1003_scene_1.ext response then
> post http://videos.****.net/ar/ar_1003_scene_1.ext to client
> post http://videos1.****.com/ar/ar_1003_scene_1.ext to client

I hope that makes sense.

I thought of doing a WebRequest/WebResponse but i don't want the file to come back, i just wanna know if its there or not. My site is on a single server while all the video is on a CDN.

(i can't post the url because it's NSFW)

Edit: Why do posts not auto format?!?

"Read Only" Access Error when checking in documents from outlook



We are accessing our sharepoint services 3.0 document library through outlook 2007.

We can open the files in word/excel etc, but when we go to check-in the document the application tells us that we only have read access to the document, and cant check the document back in to the server.

It works fine via the browser, the read only problem is only when checking out through outlook.

I have given all users full access and design access to the doc library.

Any help would be greatly appreciated.






Errors checking documents out


Dear all

I've recently had SharePoint set up and I've created my first shared document list. I changed the settings to switch on checking out and I'm now getting errors. The error occurs when I click OK on the 'you are about to open...' dialogue with 'edit' selected. The error comes up in a new box and it states 'object reference not set to an instance of an object'. When I click OK it gives a message stating I may not have permissions or that the file is currently checked out by someone else. I have permissions to the whole site so I don't think that is the problem, and I know for sure that the files are not checked out (i tested this by uploading a new file and trying to check it out).

Many thanks in advance for comments and suggestions.


How to increment default dates in the subscription


I have a report that I want run on a monthly subscription, but the report has a default date parameter. Is there a way to have the default date parameter increment each month. So if I choose to receive the subscription monthly I would want that default date to increment.

Get Dates from Sunday thru Saturday


I'm using the date picker and I need to know how (or if it's even possible), to select a date, and based on the date, have the actual query use the week the date was in and return all the records from that week (Sunday through Saturday)

Like - if I pick 8/24/2010 - it returns a date range of 8/22 through 8/28
I'd also like to display the date range in the report, somehow

Any ideas on how I do this?

Regex for checking number greater than 9

Hi All , I need to write a regex which can check for a number greater than equal to 9 .  

Custom Dataflow componet in Null checking

Hi I want to create the custom Null checking and data length checking component. like Dataprofiling Please suggest it. Regards Ram  

Dynamic query for Null field checking

Hi I want dynamiclly find the table to null values finding.. Please give me quickly   Regards Ram

Dynamic query for datalength field checking

Hi   Please tell me the dynamic query length in table

Dynamic query for Null field checking

Hi I want dynamically check the data Formation query in SQL server please  provide me the query

QUERY filter dates by DAY

i have the following data : first column: dates and 2nd column: values i want to filter the dates per day and calculate the AVERAGE of their values per day i can filter them manually by setting day(datetimefield) = 12 and calculate the AVERGAE but i dont know how to do it for all in one query? each record resulting the average of that day   2010-07-12 00:00:00.000 900 2010-07-12 10:00:00.000 1000 2010-07-12 10:10:00.000 1200 2010-07-12 12:00:00.000 1100 2010-07-12 15:00:00.000 1300 2010-07-12 15:10:00.000 1500 2010-07-13 00:00:00.000 6500 2010-07-13 10:00:00.000 5500 2010-07-14 00:00:00.000 5500 2010-07-14 10:00:00.000 4400 2010-07-15 10:00:00.000 4500 2010-07-16 00:00:00.000 1000 2010-07-17 00:00:00.000 7000 2010-07-18 00:00:00.000 8500 2010-07-19 00:00:00.000 1500 2010-07-20 00:00:00.000 1700 2010-07-21 00:00:00.000 1900 2010-07-22 00:00:00.000 2000  

Hiding other month dates in ASP .Net Calendar Control

Often we need ASP .Net calendar control in our webpages. Most of the times we require navigation in between dates of the calendar control but there can be a requirement that when we want that users should not be able to select dates from month other than the current month.Some people might be thinking in mind that Microsoft has provided theShowNextPrevMonth property of a calendar control which can be set to false in order to disable the navigation in between months. Ok, this will disable navigation but what about the dates of adjacent months shown in current month?Following is the output of a normal Calendar control when ShowNextPrevMonth is not set to false.Note the red circles in above image. July and September will allow you to navigate through other months and red circles below will allow you to select dates of adjacent months.Ok now we set the ShowNextPrevMonth property to false and see the output. Following is the output in this case.So setting out the ShowNextPrevMonth property has disabled the July and Septemberlinks but dates of adjacent months are still there which can be selected as well. How to disable/hide these? Unfortunately there is no such default property provided using which one can disable or hide these dates but fortunately doing this using code is not a complex task. Use following code a

Checking out Web Matrix

I dont recall seeing if webmatrix requires asp.net 4.0,  does it?  
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