Date column in datagridview


Author
Message
Charles R Hankey
Charles R Hankey
StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)
Group: Forum Members
Posts: 524, Visits: 30K
So many good reasons to either not use datagridviews for data entry or to use a 3rd party grid that has more capability BUT



Suppose I need to use a standard MS datagridview with a BBS.



I can set the format to d for a short date but in BO mapper I use either generic for nulls or #1/1/1800# for replace/value.



Either way, as soon as you enter a date field in grid you get 1/1/1800. Then if you enter an invalid date it throws an error.



Any tricks for using the datagridview? Ideally I'll like to have the datetimepicker in that column, but I'm a bit of an idiot as to how to build the grid manually if I do that and it seems pretty labor intensive since you can't just pick that as a control type for the column.



Suggestions? Doesn't have to be fancy, just user friendly for entering dates



( next time around I'll be using an infragistics grid where I think there are more options )



TIA
Replies
Charles R Hankey
Charles R Hankey
StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)
Group: Forum Members
Posts: 524, Visits: 30K
Edhy Thank you! You're a better googler than I am Smile



I googled around quite a bit and didn't hit that second link which is definitely what I'm looking for.



Edhy Rijo
E
StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
You are welcome Charles.



Well basically what I do with Google is I enter the following search expression:



"vb.net how to use datetimepicker in datagridview"




Also some times I go to the Google Microsoft page http://www.google.com/microsoft and to do my search.

Edhy Rijo

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search