Why, thank you ! :-)
On Sep 15, 11:44 pm, CK <[EMAIL PROTECTED]> wrote:
> Very good posts today, C :)
>
> On 15 Sep, 17:59, Cerebrus <[EMAIL PROTECTED]> wrote:
>
>
>
> > Hi Nelson,
>
> > You implied that this is your first post... so I guess a Welcome is in
> > order :
>
> > Welcome to the Group. Hope you find your time spent here very
> > satisfying! Looking forward to many contributions from your side. :-)
>
> > About your question, I am of the opinion that the format (Note: NOT
> > datatype) of values in the database should never be decided by the
> > desired formatting required by your UI. Even in MS Access, the display
> > format ("Medium date" in your case) affects only how the date is
> > displayed (for instance, in Access forms and reports) rather than how
> > the date is stored. If your "Medium date" setting were in fact getting
> > applied to the stored date, I doubt if you would find a value like
> > "6/9/2008 12:02" being retrieved by your VB.NET code. IIRC, this is
> > the "General date" format.
>
> > Therefore, the point is that the responsibility of formatting
> > datatypes such as dates is entirely on the UI Layer. In your code, you
> > could use the following string format to output a date as per your
> > requirement : "dd-MMM-yyyy". I think you can use the overload of the
> > Binding class constructor that accepts a string format or set the
> > FormatString property as follows :
>
> > ---
> > Dim b as New Binding("Text", OleDS, "Clients.ClnRdt", true)
> > b.FormatString = "dd-MMM-yyyy"
> > ---
>
> > On Sep 15, 9:55 am, "Nelson Bernard" <[EMAIL PROTECTED]> wrote:
>
> > > Dear Sirs,
>
> > > I have been going thru the postings by this group which i felt was very
> > > useful. Now i have started development and thus require your kind
> > > assistance
> > > and help by all means. I am also new to VB.NET programming, therefore i
> > > kindly request you to help me out with my doubts.
>
> > > I am using MS-Access database as back-end. One of my field (ClnRdt) as
> > > "Date/Time" data type and i have set the format as "Medium Date". I am now
> > > binding the field to a textbox (txtClnRdt) in my form. But while the data
> > > is
> > > retreived from the Table the date/time content is displayed as "6/9/2008
> > > 12:02" instead i need to display as "06-Sep-2008". Please can somebody
> > > help
> > > me to format the data field ClnRdt while binding to the text box. At
> > > present
> > > am using the following code to bind.
>
> > > Me.txtClnRegDt.DataBindings.Add(New Binding("Text", OleDS,
> > > "Clients.ClnRdt"))
>
> > > Please can somebody help me to format the content of binding field data.
>
> > > Thanks & Regards,
>
> > > Nelson Bernard- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
Services,.NET Remoting" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://cm.megasolutions.net/forums/default.aspx
-~----------~----~----~----~------~----~------~--~---
