Click here to Skip to main content
14,826,992 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
GeneralRe: An unhandled exception of type 'System.AccessViolationException' occurred in System.Data.dll Pin
Richard MacCutchan5-Oct-17 21:03
mveRichard MacCutchan5-Oct-17 21:03 
AnswerRe: An unhandled exception of type 'System.AccessViolationException' occurred in System.Data.dll Pin
Eddy Vluggen5-Oct-17 3:45
professionalEddy Vluggen5-Oct-17 3:45 
GeneralRe: An unhandled exception of type 'System.AccessViolationException' occurred in System.Data.dll Pin
indian1435-Oct-17 7:46
Memberindian1435-Oct-17 7:46 
GeneralRe: An unhandled exception of type 'System.AccessViolationException' occurred in System.Data.dll Pin
Eddy Vluggen6-Oct-17 1:51
professionalEddy Vluggen6-Oct-17 1:51 
QuestionImport Date values from Pipe-Delimited file to SQL Server table Pin
indian1433-Oct-17 21:07
Memberindian1433-Oct-17 21:07 
SuggestionRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
Richard MacCutchan3-Oct-17 21:38
mveRichard MacCutchan3-Oct-17 21:38 
AnswerRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
Mycroft Holmes3-Oct-17 21:38
professionalMycroft Holmes3-Oct-17 21:38 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
indian1434-Oct-17 6:58
Memberindian1434-Oct-17 6:58 
Hi,

thanks I saw that, Date field is coming as empty or null, can you please help me in adding Condition in the below expression so that it can check for the empty string or null else it will take the DateTime.Min value - thanks in advance my friend.
(DT_DBDATE)(SUBSTRING ([Date Posted] ,1,2) + "-"+ SUBSTRING([Date Posted] ,3,2) + "-" + SUBSTRING([Date Posted] ,5,4))

Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
Richard MacCutchan4-Oct-17 22:24
mveRichard MacCutchan4-Oct-17 22:24 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
indian1435-Oct-17 3:15
Memberindian1435-Oct-17 3:15 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
Richard MacCutchan5-Oct-17 3:25
mveRichard MacCutchan5-Oct-17 3:25 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
indian1435-Oct-17 3:35
Memberindian1435-Oct-17 3:35 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
Richard MacCutchan5-Oct-17 3:51
mveRichard MacCutchan5-Oct-17 3:51 
AnswerRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
Gerry Schmitz4-Oct-17 6:02
mveGerry Schmitz4-Oct-17 6:02 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table - able to achieve but a small issue still remaining Pin
indian1434-Oct-17 7:06
Memberindian1434-Oct-17 7:06 
QuestionImprove the performance of the reading of Excel Files using interop Pin
indian1433-Oct-17 11:45
Memberindian1433-Oct-17 11:45 
AnswerRe: Improve the performance of the reading of Excel Files using interop Pin
Dave Kreskowiak3-Oct-17 13:42
mveDave Kreskowiak3-Oct-17 13:42 
AnswerRe: Improve the performance of the reading of Excel Files using interop Pin
Gerry Schmitz4-Oct-17 5:37
mveGerry Schmitz4-Oct-17 5:37 
SuggestionRe: Improve the performance of the reading of Excel Files using interop Pin
Richard Deeming4-Oct-17 9:15
mveRichard Deeming4-Oct-17 9:15 
AnswerRe: Improve the performance of the reading of Excel Files using interop Pin
Patrice T7-Oct-17 15:43
mvePatrice T7-Oct-17 15:43 
QuestionArranging the box concept Pin
Member 1289648327-Sep-17 4:29
MemberMember 1289648327-Sep-17 4:29 
AnswerRe: Arranging the box concept Pin
Pete O'Hanlon27-Sep-17 4:31
mvePete O'Hanlon27-Sep-17 4:31 
AnswerRe: Arranging the box concept Pin
Eddy Vluggen27-Sep-17 5:30
professionalEddy Vluggen27-Sep-17 5:30 
QuestionConverting 32 bit Excel Files to 64 bit Excel files Programatically Pin
indian14326-Sep-17 6:53
Memberindian14326-Sep-17 6:53 
AnswerRe: Converting 32 bit Excel Files to 64 bit Excel files Programatically Pin
Richard Deeming26-Sep-17 7:28
mveRichard Deeming26-Sep-17 7:28 

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.