Click here to Skip to main content
14,635,091 members
Home » Discussions » Database
   

Database

 
AnswerRe: data between 1st jan to December 31st of previous year query --no hard coded dates. Pin
Chris Quinn27-Dec-17 0:01
MemberChris Quinn27-Dec-17 0:01 
AnswerRe: data between 1st jan to December 31st of previous year query --no hard coded dates. Pin
jschell1-Jan-18 7:11
Memberjschell1-Jan-18 7:11 
Rant[REPOST] data between 1st jan to December 31st of previous year query --no hard coded dates. Pin
Richard Deeming8-Jan-18 7:27
mveRichard Deeming8-Jan-18 7:27 
QuestionOLE DB Data Types to C# Data Type Mapping Pin
User9874325-Dec-17 17:55
professionalUser9874325-Dec-17 17:55 
AnswerRe: OLE DB Data Types to C# Data Type Mapping Pin
Richard MacCutchan25-Dec-17 20:55
mveRichard MacCutchan25-Dec-17 20:55 
AnswerRe: OLE DB Data Types to C# Data Type Mapping Pin
Mycroft Holmes25-Dec-17 21:33
professionalMycroft Holmes25-Dec-17 21:33 
GeneralRe: OLE DB Data Types to C# Data Type Mapping Pin
User9874325-Dec-17 22:57
professionalUser9874325-Dec-17 22:57 
GeneralRe: OLE DB Data Types to C# Data Type Mapping Pin
jschell26-Dec-17 7:39
Memberjschell26-Dec-17 7:39 
Presumably you verified that the exception is coming from that exact line.

Extract the column as a generic object and then print that out. That will tell you the exact data type.

If that doesn't help then post the output from the above along with the class cast exception text.
GeneralRe: OLE DB Data Types to C# Data Type Mapping Pin
User9874314-Jan-18 10:44
professionalUser9874314-Jan-18 10:44 
SuggestionRe: OLE DB Data Types to C# Data Type Mapping Pin
Richard Deeming8-Jan-18 7:38
mveRichard Deeming8-Jan-18 7:38 
GeneralRe: OLE DB Data Types to C# Data Type Mapping Pin
User9874314-Jan-18 10:50
professionalUser9874314-Jan-18 10:50 
QuestionT-SQL and denomalization of Parent and Child hierarchy Tables Pin
Member 1358789920-Dec-17 21:41
MemberMember 1358789920-Dec-17 21:41 
AnswerRe: T-SQL and denomalization of Parent and Child hierarchy Tables Pin
Victor Nijegorodov21-Dec-17 1:54
MemberVictor Nijegorodov21-Dec-17 1:54 
QuestionTo convert an Excel file to CSV and then move that data from CSV to oracle database. Pin
sai.201218-Dec-17 8:23
Membersai.201218-Dec-17 8:23 
AnswerRe: To convert an Excel file to CSV and then move that data from CSV to oracle database. Pin
jschell18-Dec-17 15:51
Memberjschell18-Dec-17 15:51 
QuestionRe: To convert an Excel file to CSV and then move that data from CSV to oracle database. Pin
Richard MacCutchan18-Dec-17 21:35
mveRichard MacCutchan18-Dec-17 21:35 
QuestionMicrosoft SQL Server VS PostgresSQL Pin
Zeyad Jalil18-Dec-17 0:02
professionalZeyad Jalil18-Dec-17 0:02 
AnswerRe: Microsoft SQL Server VS PostgresSQL Pin
Nathan Minier18-Dec-17 1:13
professionalNathan Minier18-Dec-17 1:13 
AnswerRe: Microsoft SQL Server VS PostgresSQL Pin
jschell18-Dec-17 15:52
Memberjschell18-Dec-17 15:52 
QuestionOverwrite from DB as windows Services Pin
Member 1204258517-Dec-17 18:46
MemberMember 1204258517-Dec-17 18:46 
AnswerRe: Overwrite from DB as windows Services Pin
Victor Nijegorodov17-Dec-17 20:54
MemberVictor Nijegorodov17-Dec-17 20:54 
QuestionBuying of referrals Pin
Member 1357942916-Dec-17 0:13
MemberMember 1357942916-Dec-17 0:13 
AnswerRe: Buying of referrals Pin
Richard MacCutchan16-Dec-17 0:49
mveRichard MacCutchan16-Dec-17 0:49 
GeneralRe: Buying of referrals Pin
Member 1357942916-Dec-17 2:41
MemberMember 1357942916-Dec-17 2:41 
GeneralRe: Buying of referrals Pin
OriginalGriff16-Dec-17 2:43
mveOriginalGriff16-Dec-17 2:43 

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.