Click here to Skip to main content
15,899,679 members
Home / Discussions / C#
   

C#

 
GeneralInherit Tree View property problem! Pin
drey17-Jun-05 7:00
drey17-Jun-05 7:00 
GeneralRe: Inherit Tree View property problem! Pin
Carsten Zeumer7-Jun-05 8:52
Carsten Zeumer7-Jun-05 8:52 
GeneralRe: Inherit Tree View property problem! Pin
drey17-Jun-05 10:56
drey17-Jun-05 10:56 
Generalusing MS Word as mail Editor like outlook : C# Pin
parviz_rashidi7-Jun-05 6:35
parviz_rashidi7-Jun-05 6:35 
GeneralRe: using MS Word as mail Editor like outlook : C# Pin
Alex Korchemniy7-Jun-05 14:08
Alex Korchemniy7-Jun-05 14:08 
GeneralRe: using MS Word as mail Editor like outlook : C# Pin
Anonymous7-Jun-05 19:33
Anonymous7-Jun-05 19:33 
GeneralRe: using MS Word as mail Editor like outlook : C# Pin
Alex Korchemniy7-Jun-05 20:52
Alex Korchemniy7-Jun-05 20:52 
GeneralDataSet and Date in PostgreSQL Pin
sanfacio7-Jun-05 5:40
sanfacio7-Jun-05 5:40 
I everybody !

I have a little application to manage cutomers, it works under windows. I use the .Net SDK 1.1, and Sharp Develop. My Database is in a Linux server and it is PostgreSQL 8.0. I connect to that database trough the PgSqlClient .dll (http://pgsqlclient.sourceforge.net/).

Mi big problem is that I have a field Birth Date in mi Customers table, it is Date type, and stores the birth date of each customer. When I made an sql query to the database, it sends the following exception:

"Ticks must be between DateTime.MinValue.Ticks and DateTime.MaxValue.Ticks. Parameter name: ticks"

I don't know if it is because of the PgSqlClient or becasue of DataSet.

But this only happens when in my table I have a record with BirthDate lower than year 2000, I mean 1999 or before, if my record has a year such like 2000 or above, it doesn't raise exception.

My query is something like:

StringQuery = "SELECT CustNumber, BirthDate, PIN, Name FROM Customers ORDER BY CustNumber";

and when I don't select the field BirthDate, it works perfect.

I have been searching in many forums about "ticks", but no solution yet. If someone could help, thanks a lot.

By now, thanks a lot for your attention, I hope you have a great day.

Note: Sorry for the little bad english :P
GeneralVisual Studio Debugger Pin
MarkMokris7-Jun-05 5:07
MarkMokris7-Jun-05 5:07 
GeneralRe: Visual Studio Debugger Pin
Judah Gabriel Himango7-Jun-05 6:22
sponsorJudah Gabriel Himango7-Jun-05 6:22 
GeneralRe: Visual Studio Debugger Pin
nemopeti8-Jun-05 5:22
nemopeti8-Jun-05 5:22 
QuestionHow to request page if server demands SCRIPTING abitlity Pin
delemur7-Jun-05 4:57
delemur7-Jun-05 4:57 
GeneralProcess + CMD Issue Pin
Opa Knack7-Jun-05 4:31
Opa Knack7-Jun-05 4:31 
GeneralRe: Process + CMD Issue Pin
Judah Gabriel Himango7-Jun-05 4:50
sponsorJudah Gabriel Himango7-Jun-05 4:50 
GeneralRe: Process + CMD Issue Pin
Opa Knack7-Jun-05 6:11
Opa Knack7-Jun-05 6:11 
GeneralRe: Process + CMD Issue Pin
User 66587-Jun-05 9:20
User 66587-Jun-05 9:20 
QuestionHow to change name for namspaces Pin
Anonymous7-Jun-05 3:55
Anonymous7-Jun-05 3:55 
AnswerRe: How to change name for namspaces Pin
MoustafaS7-Jun-05 4:42
MoustafaS7-Jun-05 4:42 
QuestionHow to change namspaces Pin
Anonymous7-Jun-05 3:55
Anonymous7-Jun-05 3:55 
AnswerRe: How to change namspaces Pin
Judah Gabriel Himango7-Jun-05 4:41
sponsorJudah Gabriel Himango7-Jun-05 4:41 
GeneralENTER key Pin
rain7117-Jun-05 3:34
rain7117-Jun-05 3:34 
GeneralRe: ENTER key Pin
Judah Gabriel Himango7-Jun-05 4:39
sponsorJudah Gabriel Himango7-Jun-05 4:39 
GeneralRe: ENTER key Pin
rain7118-Jun-05 2:05
rain7118-Jun-05 2:05 
GeneralRe: ENTER key Pin
nemopeti8-Jun-05 5:29
nemopeti8-Jun-05 5:29 
GeneralRe: ENTER key Pin
Judah Gabriel Himango8-Jun-05 7:20
sponsorJudah Gabriel Himango8-Jun-05 7:20 

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.