Click here to Skip to main content
15,915,319 members
Home / Discussions / C#
   

C#

 
GeneralRe: Error in .Net after adding PayPal webservice - please help!! Pin
nzmike3-Aug-05 19:06
nzmike3-Aug-05 19:06 
GeneralRe: Error in .Net after adding PayPal webservice - please help!! Pin
Christian Graus3-Aug-05 19:09
protectorChristian Graus3-Aug-05 19:09 
GeneralRe: Error in .Net after adding PayPal webservice - please help!! Pin
nzmike3-Aug-05 19:21
nzmike3-Aug-05 19:21 
GeneralRe: Error in .Net after adding PayPal webservice - please help!! Pin
Christian Graus3-Aug-05 19:35
protectorChristian Graus3-Aug-05 19:35 
GeneralRe: Error in .Net after adding PayPal webservice - please help!! Pin
nzmike3-Aug-05 20:43
nzmike3-Aug-05 20:43 
GeneralASP.NET/C#/CDO COMException.. PLEASE HELP! Pin
Jonathan W. Zaleski3-Aug-05 11:21
Jonathan W. Zaleski3-Aug-05 11:21 
GeneralDate Format Pin
Ming Luo3-Aug-05 10:52
Ming Luo3-Aug-05 10:52 
GeneralRe: Date Format Pin
Rob Graham3-Aug-05 11:24
Rob Graham3-Aug-05 11:24 
The display format is independant of the way the date gets stored in Access. The default display format depends on your locale settings. To write dates to access (or any database, for that matter) the best approach is to use parameterised queries, and pass the date as a parameter of oledbtype.Date, which maps directly to System.DateTime (access uses the double seconds since 1899 as its storage type).

To display the date, you could specify the format:
<code>
date_txt.Text = System.DateTime.Today.ToString("dd/MM/yyyy")</code>


To display a date between two dates, use a parameterized query:

<code>string myQuery = "Select * from MyTable where MyDateField Between ? and ?"
OledbCommand myCommand = new OleDbCommand(myQuery, mYDbConnection);
myCommand.Parameters.Add("@StartDate",startingDateTime);
myCommand.Parameters.Add("@EndDate",endingDateTime);
OleDbDataReader dr = myCommand.ExecuteReader;
while(dr.Read())
{
...
}</code>

<small><b>Absolute faith corrupts as absolutely as absolute power<i>
Eric Hoffer</i></b></small>
<small><b>All that is necessary for the triumph of evil is that good men do nothing.
<i>Edmund Burke</i></b></small>

GeneralRe: Date Format Pin
Ming Luo4-Aug-05 6:30
Ming Luo4-Aug-05 6:30 
GeneralRe: Date Format Pin
Guffa3-Aug-05 13:16
Guffa3-Aug-05 13:16 
GeneralRe: Date Format Pin
Ming Luo4-Aug-05 6:27
Ming Luo4-Aug-05 6:27 
GeneralRe: Date Format Pin
Guffa5-Aug-05 4:08
Guffa5-Aug-05 4:08 
GeneralWindows account information Pin
lrech3-Aug-05 10:17
lrech3-Aug-05 10:17 
GeneralRe: Windows account information Pin
Peter Vertes3-Aug-05 11:28
Peter Vertes3-Aug-05 11:28 
GeneralRe: Windows account information Pin
Mohamad Al Husseiny3-Aug-05 13:10
Mohamad Al Husseiny3-Aug-05 13:10 
GeneralRe: Windows account information Pin
Mohamad Al Husseiny3-Aug-05 13:13
Mohamad Al Husseiny3-Aug-05 13:13 
GeneralSoftware Protection Pin
damir_tk3-Aug-05 9:53
damir_tk3-Aug-05 9:53 
GeneralRe: Software Protection Pin
Lars Niedziolka3-Aug-05 13:45
Lars Niedziolka3-Aug-05 13:45 
GeneralRe: Software Protection Pin
Carl Mercier3-Aug-05 15:10
Carl Mercier3-Aug-05 15:10 
GeneralRemoving Icon from a Form Pin
Luis Alonso Ramos3-Aug-05 9:41
Luis Alonso Ramos3-Aug-05 9:41 
GeneralRe: Removing Icon from a Form Pin
Dave Kreskowiak3-Aug-05 11:52
mveDave Kreskowiak3-Aug-05 11:52 
GeneralRe: Removing Icon from a Form Pin
Lars Niedziolka3-Aug-05 13:02
Lars Niedziolka3-Aug-05 13:02 
GeneralRe: Removing Icon from a Form Pin
Luis Alonso Ramos3-Aug-05 13:06
Luis Alonso Ramos3-Aug-05 13:06 
GeneralRe: Removing Icon from a Form Pin
Luis Alonso Ramos3-Aug-05 13:05
Luis Alonso Ramos3-Aug-05 13:05 
GeneralRe: Removing Icon from a Form Pin
Lars Niedziolka3-Aug-05 13:50
Lars Niedziolka3-Aug-05 13:50 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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