Click here to Skip to main content
15,867,568 members
Home / Discussions / C#
   

C#

 
QuestionC#: How to copy excel cell range and chart data to power point slides Pin
Tridip Bhattacharjee31-Jan-17 2:18
professionalTridip Bhattacharjee31-Jan-17 2:18 
AnswerRe: C#: How to copy excel cell range and chart data to power point slides Pin
#realJSOP1-Feb-17 7:05
mve#realJSOP1-Feb-17 7:05 
QuestionHow to convert total database columns datetime to date in the format of dd-mm-yyyy Pin
TarunKumarSusarapu29-Jan-17 23:35
professionalTarunKumarSusarapu29-Jan-17 23:35 
AnswerRe: How to convert total database columns datetime to date in the format of dd-mm-yyyy Pin
OriginalGriff30-Jan-17 0:05
mveOriginalGriff30-Jan-17 0:05 
GeneralRe: How to convert total database columns datetime to date in the format of dd-mm-yyyy Pin
TarunKumarSusarapu30-Jan-17 0:33
professionalTarunKumarSusarapu30-Jan-17 0:33 
GeneralRe: How to convert total database columns datetime to date in the format of dd-mm-yyyy Pin
OriginalGriff30-Jan-17 0:45
mveOriginalGriff30-Jan-17 0:45 
AnswerRe: How to convert total database columns datetime to date in the format of dd-mm-yyyy Pin
CHill6030-Jan-17 1:44
mveCHill6030-Jan-17 1:44 
GeneralRe: How to convert total database columns datetime to date in the format of dd-mm-yyyy Pin
Richard Deeming30-Jan-17 2:09
mveRichard Deeming30-Jan-17 2:09 
TarunKumarSusarapu wrote:
Now they want only date format containing dd-mm-yyyy.

Store the values in a datetime, datetime2 or date column. That will store the actual date value, without any associated formatting.
Date and Time Types[^]

Any formatting of the value should be done when you display the date values in your application or report.
  • SQL Server Reporting Services and Crystal Reports have built-in support for specifying the format of date columns.
  • In a .NET application, pass a standard[^] or custom[^] format string to the DateTime value's ToString method.
    C#
    DateTime invoiceDate = row.Field<DateTime>("INV_DATE");
    string displayValue = invoiceDate.ToString("dd-MM-yyyy");




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


GeneralRe: How to convert total database columns datetime to date in the format of dd-mm-yyyy Pin
TarunKumarSusarapu30-Jan-17 19:28
professionalTarunKumarSusarapu30-Jan-17 19:28 
GeneralRe: How to convert total database columns datetime to date in the format of dd-mm-yyyy Pin
Pete O'Hanlon30-Jan-17 19:43
subeditorPete O'Hanlon30-Jan-17 19:43 
GeneralRe: How to convert total database columns datetime to date in the format of dd-mm-yyyy Pin
TarunKumarSusarapu30-Jan-17 19:47
professionalTarunKumarSusarapu30-Jan-17 19:47 
Question.net Reading and Saving Very Large Images Pin
JBHowl26-Jan-17 3:27
JBHowl26-Jan-17 3:27 
AnswerRe: .net Reading and Saving Very Large Images Pin
Jochen Arndt26-Jan-17 3:55
professionalJochen Arndt26-Jan-17 3:55 
GeneralRe: .net Reading and Saving Very Large Images Pin
JBHowl26-Jan-17 4:25
JBHowl26-Jan-17 4:25 
GeneralRe: .net Reading and Saving Very Large Images Pin
Jochen Arndt26-Jan-17 6:08
professionalJochen Arndt26-Jan-17 6:08 
AnswerRe: .net Reading and Saving Very Large Images Pin
OriginalGriff26-Jan-17 4:31
mveOriginalGriff26-Jan-17 4:31 
AnswerRe: .net Reading and Saving Very Large Images Pin
Eddy Vluggen26-Jan-17 4:49
professionalEddy Vluggen26-Jan-17 4:49 
QuestionNeed help creating a META file (*.meta) editor Pin
KrazyMonkey Modding25-Jan-17 18:45
KrazyMonkey Modding25-Jan-17 18:45 
SuggestionRe: Need help creating a META file (*.meta) editor Pin
Richard MacCutchan25-Jan-17 21:38
mveRichard MacCutchan25-Jan-17 21:38 
AnswerRe: Need help creating a META file (*.meta) editor Pin
NotPolitcallyCorrect26-Jan-17 1:12
NotPolitcallyCorrect26-Jan-17 1:12 
AnswerRe: Need help creating a META file (*.meta) editor Pin
Dave Kreskowiak26-Jan-17 2:46
mveDave Kreskowiak26-Jan-17 2:46 
AnswerRe: Need help creating a META file (*.meta) editor Pin
Gerry Schmitz26-Jan-17 7:29
mveGerry Schmitz26-Jan-17 7:29 
QuestionDataSet to SDF in C#? Pin
Simmerliner25-Jan-17 12:37
Simmerliner25-Jan-17 12:37 
GeneralRe: DataSet to SDF in C#? Pin
Richard MacCutchan25-Jan-17 21:37
mveRichard MacCutchan25-Jan-17 21:37 
QuestionGetting value into dropdown from db MVC Pin
eejaynic25-Jan-17 8:53
eejaynic25-Jan-17 8:53 

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.