Ask a Question related to ASP.NET General, Design and Development.
-
William F. Robertson, Jr. #1
Using string format
I have a question about the string formatting function.
I have a field in a database that is coming back as a 6 digit date:
061503
I would like to format this out to 06/15/03 to be displayed on a page.
What StringFormat parameter do I apply to the Column to get this desired
result? Or should I be converting in in the SqlQuery? If the query option
is the correct one, how do I do that in the query.
Currently the field is a nvarchar that gets converted to varchar
SELECT Convert( varchar, Cycle, 1 ) as CycleDate FROM ...
Thanks,
bill
William F. Robertson, Jr. Guest
-
URL FOrmat String
Hi I am trying to learn about asp.net and I have come across the following problem. In DataGrid Columns URL format string box is not... -
Format Phone Number String in Datagrid Column
Greetings, I have a 10 digit phone number stored as a string in a SQL server table. My datagrid currently displays it as 1234567890, but I would... -
is not generated for null values when using a format string
I have a DataGrid with which formats dates <ASP:TEMPLATECOLUMN SortExpression="EST_DATE" HeaderText="Est Date"> <ITEMTEMPLATE> <ASP:LABEL... -
format string
Just a little question... How do I split 12345678 into 12 34 56 78??????? Christopher Brandsdal -
Text Format String - Please help
Hi, I need to display a DateTime field in 'mm/dd/yyyy' in a DataGrid.. On myGrid1 - Properties - Columns - myColumn1 - Text format string: I... -
James A Taber #2 Re: Using string format
Hello Bill,
Try to look at this link ...
[url]http://www.vbcentral.net/quickstart/howto/doc/format.aspx[/url]
Hope this helps...
-James A Taber
"William F. Robertson, Jr." <wfrobertson@kpmg.com> wrote in message
news:e73LYuJTDHA.1556@TK2MSFTNGP10.phx.gbl...option> I have a question about the string formatting function.
>
> I have a field in a database that is coming back as a 6 digit date:
>
> 061503
>
> I would like to format this out to 06/15/03 to be displayed on a page.
>
> What StringFormat parameter do I apply to the Column to get this desired
> result? Or should I be converting in in the SqlQuery? If the query> is the correct one, how do I do that in the query.
>
> Currently the field is a nvarchar that gets converted to varchar
>
> SELECT Convert( varchar, Cycle, 1 ) as CycleDate FROM ...
>
> Thanks,
>
> bill
>
>
James A Taber Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
