C# Discussion Boards - CodeProject

13-Apr-09 1:02

im creating a simple module to get data from access with date as filter.

now, i want user to enter date(which is in string) and get data from access.

but problem is ' conversion of string to date(only) ' and not time.

i tried parse, exactparse but each get time with date.

help me out.

Colin Angus Mackay13-Apr-09 1:37

*Developer Day Scotland - Free community conference Delegate Registration Open

13-Apr-09 1:37

The DateTime object will always contain a time element. If you use myDate.Date it will normalise the time element to be midnight.

sachees12313-Apr-09 1:44

13-Apr-09 1:44

BUT cant we eliminate time...????

Colin Angus Mackay13-Apr-09 1:46

*Developer Day Scotland - Free community conference Delegate Registration Open

13-Apr-09 1:46

At the risk of repeating myself: The DateTime object will always contain a time element.

sachees12313-Apr-09 1:56

13-Apr-09 1:56

Well, Thanks...

But i still didnt get my solution...

Roberto Ho13-Apr-09 2:11

Roberto Ho

13-Apr-09 2:11

string str = "04-13-2009";
DateTime dt = DateTime.ParseExact(str, "MM-dd-yyyy", System.Globalization.CultureInfo.InvariantCulture);

// Show the date only.
Console.WriteLine(dt.ToString("MM-dd-YYYY"));

Colin Angus Mackay13-Apr-09 2:15

*Developer Day Scotland - Free community conference Delegate Registration Open

13-Apr-09 2:15

Exactly. But the OPs complaint is that the DateTime object still contains time.

Colin Angus Mackay13-Apr-09 2:12

*Developer Day Scotland - Free community conference Delegate Registration Open

13-Apr-09 2:12

sachees123 wrote:
But i still didnt get my solution...

You seem to want the moon on a plate.

You want a string parsed to a DateTime, you do not want the time element. Your solution, and the solution everyone else uses, is to simply ignore the time part. If you are doing date calculations then normalise it by setting the time part to midnight (e.g. myDateTimeObject = myDateTimeObject.Date)

sachees12313-Apr-09 2:36

13-Apr-09 2:36

How can a query compare my date with that of ms access date???

Colin Angus Mackay13-Apr-09 2:44

*Developer Day Scotland - Free community conference Delegate Registration Open

13-Apr-09 2:44

Use a parameterised query.

With Access you use a question mark to denote where a parameter goes. Then you add the values in the Parameters collection in the same order in which the question marks appear in your query.

cmd.CommandText = "SELECT * FROM MyTable WHERE SomeDateColumn = ?";
cmd.Parameters.AddWithValue("?", myDateTimeObject);

sachees12313-Apr-09 2:53

13-Apr-09 2:53

well thanks Colin Angus Mackay and HO for your friendly support.

Things work with the

DateTime dt = DateTime.ParseExact(textBox1.Text.ToString(), "MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture);

Thanks a ton

Will come again with new problem...

c ya again

PIEBALDconsult13-Apr-09 4:06

PIEBALDconsult

13-Apr-09 4:06

Tough, move on.

execute one application from another dummy application

ramzg13-Apr-09 3:36

ramzg

13-Apr-09 3:36

Hi,

Why dont you try out using regular expressions and return only the date... I think that might solve your problem...

NetQuestions13-Apr-09 0:29

NetQuestions

13-Apr-09 0:29

normally i run application1 by opening the solution and pressing F5.

Is it possible to create a dummy application2, then include application1's DLL
by adding reference to it and execute application1 from dummy application2?

Re: execute one application from another dummy application

Colin Angus Mackay13-Apr-09 0:37