Click here to Skip to main content
15,887,334 members
Home / Discussions / C#
   

C#

 
GeneralRe: Serializing a Dictionary of Items where the Value member is a List of instances of an Interface Pin
Eddy Vluggen15-Sep-15 7:55
professionalEddy Vluggen15-Sep-15 7:55 
AnswerRe: Serializing a Dictionary of Items where the Value member is a List of instances of an Interface Pin
Bernhard Hiller15-Sep-15 5:44
Bernhard Hiller15-Sep-15 5:44 
GeneralRe: Serializing a Dictionary of Items where the Value member is a List of instances of an Interface Pin
Richard Deeming15-Sep-15 5:58
mveRichard Deeming15-Sep-15 5:58 
GeneralRe: Serializing a Dictionary of Items where the Value member is a List of instances of an Interface Pin
BillWoodruff16-Sep-15 0:22
professionalBillWoodruff16-Sep-15 0:22 
GeneralRe: Serializing a Dictionary of Items where the Value member is a List of instances of an Interface Pin
Richard Deeming16-Sep-15 2:04
mveRichard Deeming16-Sep-15 2:04 
GeneralRe: Serializing a Dictionary of Items where the Value member is a List of instances of an Interface Pin
BillWoodruff16-Sep-15 7:37
professionalBillWoodruff16-Sep-15 7:37 
GeneralRe: Serializing a Dictionary of Items where the Value member is a List of instances of an Interface Pin
BillWoodruff15-Sep-15 6:58
professionalBillWoodruff15-Sep-15 6:58 
QuestionGridView Export to Excel keeping the date format Pin
Member 1180079714-Sep-15 3:34
Member 1180079714-Sep-15 3:34 
hi,

I have written the following code to export data from Excel
string tempPath = System.IO.Path.Combine(System.IO.Path.GetTempPath(), "Report.csv");
GView.SelectAllCells();
GView.ClipboardCopyMode = DataGridClipboardCopyMode.IncludeHeader;
ApplicationCommands.Copy.Execute(null, GView);
String result = (string)Clipboard.GetData(DataFormats.CommaSeparatedValue);
GView.UnselectAllCells();
System.IO.StreamWriter file1 = new System.IO.StreamWriter(tempPath);
file1.WriteLine(result);
file1.Close();
Excel.Application app = new Excel.Application();
Excel.Workbook workbook = app.Workbooks.Open(tempPath);

Excel.Worksheet ws = workbook.Worksheets[1];

I have 2 columns contain dates. both of them looks dd/MM/yyyy on the data grid which is correct.
once out on excel they change to american date format!?
the weired thing is, before the 13th of every month they are in american format. after the 13th they show UK format.

can some guru help me please
AnswerRe: GridView Export to Excel keeping the date format Pin
Richard MacCutchan14-Sep-15 6:31
mveRichard MacCutchan14-Sep-15 6:31 
QuestionWhat is it like working as a .NET developer? Pin
Jason Smith14-Sep-15 0:54
Jason Smith14-Sep-15 0:54 
AnswerRe: What is it like working as a .NET developer? Pin
Richard MacCutchan14-Sep-15 1:01
mveRichard MacCutchan14-Sep-15 1:01 
GeneralRe: What is it like working as a .NET developer? Pin
Jason Smith14-Sep-15 1:36
Jason Smith14-Sep-15 1:36 
QuestionHow to change a textbox text while the code is running Pin
Member 1191673513-Sep-15 20:29
Member 1191673513-Sep-15 20:29 
AnswerRe: How to change a textbox text while the code is running Pin
OriginalGriff13-Sep-15 21:03
mveOriginalGriff13-Sep-15 21:03 
AnswerRe: How to change a textbox text while the code is running Pin
BillWoodruff13-Sep-15 22:04
professionalBillWoodruff13-Sep-15 22:04 
GeneralRe: How to change a textbox text while the code is running Pin
Member 1191673514-Sep-15 23:54
Member 1191673514-Sep-15 23:54 
QuestionChange speech recognition language Pin
Member 1085025313-Sep-15 16:03
Member 1085025313-Sep-15 16:03 
AnswerRe: Change speech recognition language PinPopular
Dave Kreskowiak13-Sep-15 16:09
mveDave Kreskowiak13-Sep-15 16:09 
GeneralRe: Change speech recognition language Pin
Eddy Vluggen13-Sep-15 21:39
professionalEddy Vluggen13-Sep-15 21:39 
GeneralRe: Change speech recognition language Pin
Richard MacCutchan13-Sep-15 21:54
mveRichard MacCutchan13-Sep-15 21:54 
Questionmysql bracket Pin
abdujalilc12-Sep-15 16:50
abdujalilc12-Sep-15 16:50 
AnswerRe: mysql bracket Pin
Dave Kreskowiak12-Sep-15 16:56
mveDave Kreskowiak12-Sep-15 16:56 
AnswerRe: mysql bracket Pin
Wendelius12-Sep-15 18:28
mentorWendelius12-Sep-15 18:28 
AnswerRe: mysql bracket Pin
Richard Deeming14-Sep-15 2:44
mveRichard Deeming14-Sep-15 2:44 
QuestionC# Change Directory Function Pin
Erics Johnson12-Sep-15 10:59
Erics Johnson12-Sep-15 10:59 

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.