Click here to Skip to main content
15,908,674 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralCreating a Menu with the Menu object Pin
dptalt25-Apr-08 8:40
dptalt25-Apr-08 8:40 
AnswerRe: Creating a Menu with the Menu object Pin
samMaster25-Apr-08 23:44
samMaster25-Apr-08 23:44 
GeneralRe: Creating a Menu with the Menu object Pin
dptalt28-Apr-08 9:19
dptalt28-Apr-08 9:19 
QuestionPersonality Profilling with ASP.NET? Pin
Taurian11025-Apr-08 4:55
Taurian11025-Apr-08 4:55 
AnswerRe: Personality Profilling with ASP.NET? Pin
Krazy Programmer25-Apr-08 6:08
Krazy Programmer25-Apr-08 6:08 
JokeRe: Personality Profilling with ASP.NET? Pin
Taurian11025-Apr-08 9:27
Taurian11025-Apr-08 9:27 
QuestionChanging Date Format Pin
munklefish25-Apr-08 4:40
munklefish25-Apr-08 4:40 
GeneralRe: Changing Date Format Pin
Taurian11025-Apr-08 5:25
Taurian11025-Apr-08 5:25 
Are you talking about updating the date format the way it is stored in the database? Or when you are retrieving it?

Also what is the data type of your date column is it varchar or DateTime?

If you just want to change the date format when retrieving the data then something like this will work:
SELECT
         Convert(varchar, DATEPART(yyyy, UploadDate)) + '/' + 
         Convert(varchar, DATEPART(mm, UploadDate)) + '/' + 
         Convert(varchar, DATEPART(dd, UploadDate)) as MyNewFormat
FROM
         dbo.[MytableName]

*Change the MytableName to your table and UploadeDate to your column name

hth
GeneralRe: Changing Date Format Pin
Blue_Boy25-Apr-08 9:17
Blue_Boy25-Apr-08 9:17 
GeneralRe: Changing Date Format Pin
munklefish28-Apr-08 0:24
munklefish28-Apr-08 0:24 
GeneralRe: Changing Date Format Pin
Blue_Boy28-Apr-08 0:45
Blue_Boy28-Apr-08 0:45 
GeneralRe: Changing Date Format Pin
munklefish28-Apr-08 0:50
munklefish28-Apr-08 0:50 
GeneralDiv inside another div not sizing correctly in the user control Pin
gottimukkala25-Apr-08 4:14
gottimukkala25-Apr-08 4:14 
GeneralRe: Div inside another div not sizing correctly in the user control Pin
Taurian11025-Apr-08 5:04
Taurian11025-Apr-08 5:04 
GeneralRe: Div inside another div not sizing correctly in the user control Pin
gottimukkala25-Apr-08 5:17
gottimukkala25-Apr-08 5:17 
GeneralRe: Div inside another div not sizing correctly in the user control Pin
Taurian11025-Apr-08 5:19
Taurian11025-Apr-08 5:19 
GeneralRe: Div inside another div not sizing correctly in the user control Pin
gottimukkala25-Apr-08 5:36
gottimukkala25-Apr-08 5:36 
QuestionNeed help with passing value via OnCheckedChanged event [modified] Pin
the_0live25-Apr-08 4:03
the_0live25-Apr-08 4:03 
GeneralRe: Need help with passing value via OnCheckedChanged event Pin
AlexeiXX325-Apr-08 14:07
AlexeiXX325-Apr-08 14:07 
GeneralRe: Need help with passing value via OnCheckedChanged event Pin
the_0live28-Apr-08 2:28
the_0live28-Apr-08 2:28 
GeneralRe: Need help with passing value via OnCheckedChanged event Pin
the_0live6-May-08 3:45
the_0live6-May-08 3:45 
QuestionHow to get hardcoded data to xml and that xml can be used in .Net Pin
subbu.sk25-Apr-08 2:39
subbu.sk25-Apr-08 2:39 
AnswerRe: How to get hardcoded data to xml and that xml can be used in .Net Pin
eyeseetee25-Apr-08 2:42
eyeseetee25-Apr-08 2:42 
GeneralProblume With Excel sheet Pin
santoshkomarraju25-Apr-08 2:36
santoshkomarraju25-Apr-08 2:36 
QuestionI have an error :'System.Web.UI.WebControls.GridView.Rows' is a 'property' but is used like a 'method' Pin
Saba0225-Apr-08 2:33
Saba0225-Apr-08 2:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.