Click here to Skip to main content
16,006,440 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralPop Up Form Pin
Socheat.Net4-Apr-08 18:52
Socheat.Net4-Apr-08 18:52 
GeneralRe: Pop Up Form Pin
Rupesh Kumar Swami4-Apr-08 20:49
Rupesh Kumar Swami4-Apr-08 20:49 
AnswerRe: Pop Up Form Pin
Rajesh Anuhya4-Apr-08 23:36
professionalRajesh Anuhya4-Apr-08 23:36 
GeneralRe: Pop Up Form Pin
Dave Kreskowiak5-Apr-08 13:37
mveDave Kreskowiak5-Apr-08 13:37 
GeneralRe: Pop Up Form Pin
Mycroft Holmes5-Apr-08 17:53
professionalMycroft Holmes5-Apr-08 17:53 
QuestionHow to design dataTables or DataSets for forms on different panels Pin
AAGTHosting4-Apr-08 16:23
AAGTHosting4-Apr-08 16:23 
AnswerRe: How to design dataTables or DataSets for forms on different panels Pin
Ashish Sehajpal4-Apr-08 23:48
Ashish Sehajpal4-Apr-08 23:48 
GeneralRe: How to design dataTables or DataSets for forms on different panels Pin
Mycroft Holmes5-Apr-08 17:50
professionalMycroft Holmes5-Apr-08 17:50 
QuestionHow Can i start? Pin
hassandot4-Apr-08 9:17
hassandot4-Apr-08 9:17 
AnswerRe: How Can i start? Pin
Dave Kreskowiak4-Apr-08 9:39
mveDave Kreskowiak4-Apr-08 9:39 
GeneralRe: How Can i start? Pin
hassanasp4-Apr-08 10:45
hassanasp4-Apr-08 10:45 
GeneralRe: How Can i start? Pin
Luc Pattyn4-Apr-08 12:07
sitebuilderLuc Pattyn4-Apr-08 12:07 
GeneralSaving Data Pin
tibmark4-Apr-08 7:23
tibmark4-Apr-08 7:23 
GeneralRe: Saving Data Pin
Dave Kreskowiak4-Apr-08 8:12
mveDave Kreskowiak4-Apr-08 8:12 
GeneralRe: Saving Data Pin
tibmark4-Apr-08 8:19
tibmark4-Apr-08 8:19 
GeneralRe: Saving Data Pin
Dave Kreskowiak4-Apr-08 9:36
mveDave Kreskowiak4-Apr-08 9:36 
GeneralRe: Saving Data Pin
jzonthemtn4-Apr-08 8:33
jzonthemtn4-Apr-08 8:33 
GeneralRe: Saving Data Pin
tibmark4-Apr-08 8:40
tibmark4-Apr-08 8:40 
GeneralRe: Saving Data Pin
A Wong4-Apr-08 8:57
A Wong4-Apr-08 8:57 
GeneralVB.net/excel/access - problem with strings and dates Pin
AHeavey4-Apr-08 6:59
AHeavey4-Apr-08 6:59 
GeneralRe: VB.net/excel/access - problem with strings and dates Pin
Dave Kreskowiak4-Apr-08 8:08
mveDave Kreskowiak4-Apr-08 8:08 
Well, you're biggest problem is that teh .NET 2.0 DateTime type is a structure, not a class, and therefore cannot ever be Nothing (null in C#). So, Date.Parse will fail when trying to parse String.Empty or any invalid date representation (including Nothing) into a Date value.

You're going to have to provide code that you can call with a value from each column from your Excel data that returns either a correct Date object or returns a DBNull value, possibly using Date's TryParse method. The existing Date structure methods won't do this for you.

You also have a problem with your database table using a string to represent a Date instead of the database's native DateTime type for a column. You'll have to rewrite your IncidentReportAdd method to accept Date objects instead of strings representing dates.


A guide to posting questions on CodeProject[^]



Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
     2006, 2007, 2008




Generalapplication created on vista using vb.net does not run on my xp computer!! Pin
Chun24-Apr-08 4:29
Chun24-Apr-08 4:29 
GeneralRe: application created on vista using vb.net does not run on my xp computer!! Pin
Dave Kreskowiak4-Apr-08 5:08
mveDave Kreskowiak4-Apr-08 5:08 
GeneralRe: application created on vista using vb.net does not run on my xp computer!! Pin
Chun24-Apr-08 5:36
Chun24-Apr-08 5:36 
GeneralRe: application created on vista using vb.net does not run on my xp computer!! Pin
Dave Kreskowiak4-Apr-08 5:57
mveDave Kreskowiak4-Apr-08 5:57 

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.