StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Date column in datagridview

Date column in datagridview

Charles R Hankey — Thu, 25 Mar 2010 22:18:45 GMT

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

RE: Date column in datagridview

Edhy Rijo — Thu, 25 Mar 2010 22:18:45 GMT

You are welcome Charles.

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

[quote]"vb.net how to use datetimepicker in datagridview"[/quote]

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

RE: Date column in datagridview

Charles R Hankey — Thu, 25 Mar 2010 21:50:12 GMT

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.

RE: Date column in datagridview

Edhy Rijo — Thu, 25 Mar 2010 21:16:17 GMT

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.

[url=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.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[/url]

[url=http://www.vbdotnetforums.com/winforms-grids/17524-add-datetimepicker-datagridview.html]http://www.vbdotnetforums.com/winforms-grids/17524-add-datetimepicker-datagridview.html[/url]