Re: Datetime problem - ASP.NET Discussion Boards

greendragons6-Aug-09 7:11

6-Aug-09 7:11

I am creating a site for social gathering as a part of my project...i want that unaccepted friend request should be deleted after 10 days. For this im using current date time and substracting it with the date time selected from database(datetime when friend request was sent)..its giving value of datetime but i just want date part of it not time so that i can convert into int and compare it with 10..if greater than 10 then delete that record..

Re: Datetime problem

Abhijit Jana6-Aug-09 7:26

Abhijit Jana

6-Aug-09 7:26

How you are planning for implement it. I will suggest you to forget about to ASP.NET, Implement this part using SQL Server only ( IF your DB is SQL Server ).
Create a SQL Server Job Agent, which will check for some status from DB, if this is unaccepted then delete the request.
Hope you understood what I mean.

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Re: Datetime problem

greendragons6-Aug-09 7:30

greendragons

6-Aug-09 7:30

I have some issues with sql on my vista so unfortunately i have to use ms access.. Frown | :(

Re: Datetime problem

Abhijit Jana6-Aug-09 7:48

Abhijit Jana

6-Aug-09 7:48

greendragons wrote:
I have some issues with sql on my vista so unfortunately i have to use ms access..

Why what is the problem, for what you want to move total database to MS-SQL to Access ? OMG | :OMG:

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Re: Datetime problem

greendragons6-Aug-09 8:10

greendragons

6-Aug-09 8:10

Not moved db..instead i cant find option to open database in sql configuration manager..sql server surface area coniguration and sql server config manager r the only two icons i can see. I cant' find option to create db , add tables n all..i tried hard..even sql express was not working before but anyhow i managed to enable that bt still it shows account login failed..

Re: Datetime problem

Abhijit Jana6-Aug-09 8:18

Abhijit Jana

6-Aug-09 8:18

You need SQL Server Management Studio for it. Please Install SSMS. Smile | :)

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Re: Datetime problem

greendragons6-Aug-09 8:16

greendragons

6-Aug-09 8:16

Do u have yahoo id..i want to solve my some queries..they are headache from long time please..my id is dorian_yates2007@yahoo.co.in

Re: Datetime problem

Abhijit Jana6-Aug-09 8:19

Abhijit Jana

6-Aug-09 8:19

greendragons wrote:
Do u have yahoo id..i want to solve my some queries.

You are welcome. Check my ID from my profile Page. Feel free to drop me mail.

Thanks.

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Re: Datetime problem

greendragons6-Aug-09 8:28

greendragons

6-Aug-09 8:28

Sure..but what about my problem is ther anyway that i can get just date part from datetime object..?

Re: Datetime problem

Abhijit Jana6-Aug-09 8:34

Abhijit Jana

6-Aug-09 8:34

greendragons wrote:
that i can get just date part from datetime object..?

U are asking for C# or SQL ?
here it for SQL

DECLARE @DateOnly DATETIME<br />
SET @DateOnly = CAST(FLOOR(CAST(GetDate() AS FLOAT)) AS DATETIME)

Details Source : Check

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Re: Datetime problem

greendragons6-Aug-09 8:44

greendragons

6-Aug-09 8:44

For c#

Re: Datetime problem

Abhijit Jana6-Aug-09 8:47

Abhijit Jana

6-Aug-09 8:47

greendragons wrote:
For c#

This is genral syntax.
DateTime.Now.ToShortDateString(); Big Grin | :-D

Some more clarification :

DateTime dt=DateTime.Now;
int year=dt.Year;
int month=dt.Month;
int day=dt.Day;

Hope this will help you Big Grin | :-D

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Re: Datetime problem

greendragons6-Aug-09 8:54

greendragons

6-Aug-09 8:54

Thnx alot

it's working..
Timespan ko = date1.subtract(dtc);

int day= ko.days;
now i can eaisly check dates THNX!

Re: Datetime problem

Abhijit Jana6-Aug-09 8:56

Abhijit Jana

6-Aug-09 8:56

You are welcome ! Wink | ;)

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Re: Datetime problem

Blue_Boy6-Aug-09 10:42

Blue_Boy

6-Aug-09 10:42

string dateValue = DateTime.Now.ToString("dd.MM.yyyy");

Just hoping this will helps you more. Smile | :)

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

www.aktualiteti.com

Need help on my Map control application

LucBite6-Aug-09 5:01

LucBite

6-Aug-09 5:01

I am developing an asp.net map control application to help people who cannot find their way to their destination when they go to events, any tips on how i can find something similar to google earth in order to make my application functional?

ML Lingwati

Re: Need help on my Map control application

Abhijit Jana6-Aug-09 7:29

Abhijit Jana

6-Aug-09 7:29

Why you are not using google map.
Please check this article from Code Project,
Google Maps in HTML, ASP.NET, PHP, JSP etc. with ease By Abhishek Sur

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Two web applications question.

Hristiyan6-Aug-09 4:28

Hristiyan

6-Aug-09 4:28

Good day!

I have an ASP.NET web application , but i want to add a forum.
I've choosen the YAF ( Yet Another Forum ). Since its a whole new ( different ) web application i'm having trouble hosting both ( because that way i'll have to pay for hosting every individual application ).
My goal is to achieve by url rewriting : forum.XXXXXXXX.com - the forum where www.XXXXXXXXX.com is the main domain name.
Is it possible for somehow merge the two applications ?
I'm not quite sure what to google

Regards, Hris

Re: Two web applications question.

kstls6-Aug-09 6:03

kstls

6-Aug-09 6:03

Are you not able to create a sub-domain for your
main domain without having to pay extra?

Re: Two web applications question.

Hristiyan6-Aug-09 12:26

Hristiyan

6-Aug-09 12:26

Good evening. Thanks for your quick response !

So what you are saying is that i need to buy a subdomain and host the forum application separately ?

Regards, Hris

MAC Validation failed on web cluster

imnotso#6-Aug-09 4:11

imnotso#

6-Aug-09 4:11

I have an C# .NET web app...small but perfectly formed. We have upgraded to .NET2. We now get an error on navigating off 1 page. When the user clicks 1 of the 2 buttons the app crashes with the well know error.....

'Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that  configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster.

Now before you all shout 'put the machine code in the webconfig', I have, on all 7 of the the front ends. And it hasn't cured it. And if it is so important, then how come the rest of the app was working fine without it?

Now I know it's related to viewstate and the fact that the postback can go to another server but I don't know much more.

I have added <enableViewStateMac="false">, this works a treat, cures my problem but has been deemed an unnacceptable fix by our solution architect. Something to do with security.

And suggestions on my next move would be welcome.

Thanks

Re: MAC Validation failed on web cluster

Parwej Ahamad6-Aug-09 6:08

Parwej Ahamad

6-Aug-09 6:08

Hi,

I am also trying to reproduce locally this issue. So that I can trace more specific solution. For the mean while please go throught with this thread:

http://forums.asp.net/p/955145/1173230.aspx[^]

http://blogs.msdn.com/tom/archive/2008/03/14/validation-of-viewstate-mac-failed-error.aspx[^]

Parwej Ahamad
http://parwej.wordpress.com/

ASP.NET Webservice clients

Piya B6-Aug-09 3:57

Piya B

6-Aug-09 3:57

Hello friends,

I made a simple ASP.NET Webservice with one methode that needs some parameters:

[WebMethod]
        public String Person(string Id, string username, string pw)
        {
           //do something
           //return string        
        }

My question is, can a PHP client use this service?

Thanks in advance.

Re: ASP.NET Webservice clients

Abhijit Jana6-Aug-09 4:39

Abhijit Jana

6-Aug-09 4:39

Web Service can be consume by any one. As this is an SOAP XML format

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Selecting from a dropdown menu without the whole page refreshing itself.

LucBite6-Aug-09 3:47

LucBite

6-Aug-09 3:47

I want to know how to be able to interact with asp page controls like buttons and dropdown lists without the whole page refreshing and also be able to use the query string to update the content within the contols without the whole page refreshing itself. Thank you in advance

ML Lingwati

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.