Click here to Skip to main content
14,772,911 members
Home » Discussions » Database
   

Database

 
AnswerRe: data between 1st jan to December 31st of previous year query --no hard coded dates. Pin
Victor Nijegorodov26-Dec-17 23:06
MemberVictor Nijegorodov26-Dec-17 23:06 
AnswerRe: data between 1st jan to December 31st of previous year query --no hard coded dates. Pin
Chris Quinn27-Dec-17 1:01
MemberChris Quinn27-Dec-17 1:01 
AnswerRe: data between 1st jan to December 31st of previous year query --no hard coded dates. Pin
jschell1-Jan-18 8:11
Memberjschell1-Jan-18 8:11 
Rant[REPOST] data between 1st jan to December 31st of previous year query --no hard coded dates. Pin
Richard Deeming8-Jan-18 8:27
mveRichard Deeming8-Jan-18 8:27 
QuestionOLE DB Data Types to C# Data Type Mapping Pin
User9874325-Dec-17 18:55
professionalUser9874325-Dec-17 18:55 
AnswerRe: OLE DB Data Types to C# Data Type Mapping Pin
Richard MacCutchan25-Dec-17 21:55
mveRichard MacCutchan25-Dec-17 21:55 
AnswerRe: OLE DB Data Types to C# Data Type Mapping Pin
Mycroft Holmes25-Dec-17 22:33
professionalMycroft Holmes25-Dec-17 22:33 
GeneralRe: OLE DB Data Types to C# Data Type Mapping Pin
User9874325-Dec-17 23:57
professionalUser9874325-Dec-17 23:57 
Well, I just spent the better part of the afternoon yesterday creating this chart myself. LOL

Can't seem to get past this. Everything I do is giving me an invalid cast exception.

I'm using GetOleDbSchemaTable ( OleDbSchemaGuid.Columns, ...)

I thought had a breakthrough, when I read that my cast was failing because it needed unboxed, so this one worked:

long ORDINAL_POSITION = (long)row.Field<Int64> ( "ORDINAL_POSITION" );

But the Data_Type is not working. The documentation says it's a
UInt16
which I should be able to cast like this:
ushort DATA_TYPE = (ushort)row.Field<UInt16> ( "DATA_TYPE" );
but that gives me the same invalid cast exception. I can't even be sure that the cast that is causing the exception is ushort and UInt16 because I'm not understanding where to look.
GeneralRe: OLE DB Data Types to C# Data Type Mapping Pin
jschell26-Dec-17 8:39
Memberjschell26-Dec-17 8:39 
GeneralRe: OLE DB Data Types to C# Data Type Mapping Pin
User9874314-Jan-18 11:44
professionalUser9874314-Jan-18 11:44 
SuggestionRe: OLE DB Data Types to C# Data Type Mapping Pin
Richard Deeming8-Jan-18 8:38
mveRichard Deeming8-Jan-18 8:38 
GeneralRe: OLE DB Data Types to C# Data Type Mapping Pin
User9874314-Jan-18 11:50
professionalUser9874314-Jan-18 11:50 
QuestionT-SQL and denomalization of Parent and Child hierarchy Tables Pin
Member 1358789920-Dec-17 22:41
MemberMember 1358789920-Dec-17 22:41 
AnswerRe: T-SQL and denomalization of Parent and Child hierarchy Tables Pin
Victor Nijegorodov21-Dec-17 2:54
MemberVictor Nijegorodov21-Dec-17 2:54 
QuestionTo convert an Excel file to CSV and then move that data from CSV to oracle database. Pin
sai.201218-Dec-17 9:23
Membersai.201218-Dec-17 9:23 
AnswerRe: To convert an Excel file to CSV and then move that data from CSV to oracle database. Pin
jschell18-Dec-17 16:51
Memberjschell18-Dec-17 16:51 
QuestionRe: To convert an Excel file to CSV and then move that data from CSV to oracle database. Pin
Richard MacCutchan18-Dec-17 22:35
mveRichard MacCutchan18-Dec-17 22:35 
QuestionMicrosoft SQL Server VS PostgresSQL Pin
Zeyad Jalil18-Dec-17 1:02
professionalZeyad Jalil18-Dec-17 1:02 
AnswerRe: Microsoft SQL Server VS PostgresSQL Pin
Nathan Minier18-Dec-17 2:13
professionalNathan Minier18-Dec-17 2:13 
AnswerRe: Microsoft SQL Server VS PostgresSQL Pin
jschell18-Dec-17 16:52
Memberjschell18-Dec-17 16:52 
QuestionOverwrite from DB as windows Services Pin
Member 1204258517-Dec-17 19:46
MemberMember 1204258517-Dec-17 19:46 
AnswerRe: Overwrite from DB as windows Services Pin
Victor Nijegorodov17-Dec-17 21:54
MemberVictor Nijegorodov17-Dec-17 21:54 
QuestionBuying of referrals Pin
Member 1357942916-Dec-17 1:13
MemberMember 1357942916-Dec-17 1:13 
AnswerRe: Buying of referrals Pin
Richard MacCutchan16-Dec-17 1:49
mveRichard MacCutchan16-Dec-17 1:49 
GeneralRe: Buying of referrals Pin
Member 1357942916-Dec-17 3:41
MemberMember 1357942916-Dec-17 3:41 

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.