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

Hi Charles,



I love Google... The first link is the search I did, and the second one is one sample on how to add a DateTimePicker to the DataGridView, of course you would want to use the SF class for the DateTimePicker, I don't know if it will work, but it is a start.



http://www.google.com/search?q=vb.net+how+to+use+datetimepicker++in+datagridview&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a



http://www.vbdotnetforums.com/winforms-grids/17524-add-datetimepicker-datagridview.html

Edhy Rijo

Edhy Thank you! You're a better googler than I am



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

You are welcome Charles.



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







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

Edhy Rijo