Click here to Skip to main content
15,902,114 members
Home / Discussions / C#
   

C#

 
GeneralMessage Closed Pin
18-Nov-14 1:17
Member 1111384118-Nov-14 1:17 
GeneralRe: Help on my African Game writing. Pin
OriginalGriff18-Nov-14 1:37
mveOriginalGriff18-Nov-14 1:37 
SuggestionRe: Help on my African Game writing. Pin
ZurdoDev18-Nov-14 2:06
professionalZurdoDev18-Nov-14 2:06 
GeneralRe: Help on my African Game writing. Pin
Member 1111384118-Nov-14 2:30
Member 1111384118-Nov-14 2:30 
AnswerRe: Help on my African Game writing. Pin
ZurdoDev18-Nov-14 2:33
professionalZurdoDev18-Nov-14 2:33 
QuestionCalling SSIS package from c# Pin
KhandelwalA17-Nov-14 18:32
KhandelwalA17-Nov-14 18:32 
AnswerRe: Calling SSIS package from c# Pin
ZurdoDev18-Nov-14 2:08
professionalZurdoDev18-Nov-14 2:08 
QuestionC#.net Pin
alpesh koriya16-Nov-14 20:06
alpesh koriya16-Nov-14 20:06 
AnswerRe: C#.net Pin
Mycroft Holmes16-Nov-14 20:48
professionalMycroft Holmes16-Nov-14 20:48 
GeneralRe: C#.net Pin
alpesh koriya16-Nov-14 22:24
alpesh koriya16-Nov-14 22:24 
GeneralRe: C#.net Pin
alpesh koriya16-Nov-14 22:25
alpesh koriya16-Nov-14 22:25 
AnswerRe: C#.net Pin
Pete O'Hanlon16-Nov-14 22:34
mvePete O'Hanlon16-Nov-14 22:34 
AnswerRe: C#.net Pin
Gerry Schmitz17-Nov-14 1:14
mveGerry Schmitz17-Nov-14 1:14 
Generalhow to make self signed code in xamarin IOS8 v2010 [moved] Pin
AhmedOsamaMoh16-Nov-14 19:57
AhmedOsamaMoh16-Nov-14 19:57 
AnswerRe: how to make self signed code in xamarin IOS8 v2010 Pin
CBadger16-Nov-14 20:05
professionalCBadger16-Nov-14 20:05 
GeneralRe: how to make self signed code in xamarin IOS8 v2010 Pin
Jacquers16-Nov-14 20:11
Jacquers16-Nov-14 20:11 
GeneralRe: how to make self signed code in xamarin IOS8 v2010 Pin
Mycroft Holmes16-Nov-14 20:31
professionalMycroft Holmes16-Nov-14 20:31 
GeneralRe: how to make self signed code in xamarin IOS8 v2010 Pin
OriginalGriff16-Nov-14 20:22
mveOriginalGriff16-Nov-14 20:22 
GeneralRe: how to make self signed code in xamarin IOS8 v2010 Pin
Richard Deeming17-Nov-14 3:07
mveRichard Deeming17-Nov-14 3:07 
QuestionQuery work in Access Query, but don't work in C# Pin
nta_388616-Nov-14 19:45
nta_388616-Nov-14 19:45 
AnswerRe: Query work in Access Query, but don't work in C# Pin
Mycroft Holmes16-Nov-14 20:43
professionalMycroft Holmes16-Nov-14 20:43 
AnswerRe: Query work in Access Query, but don't work in C# Pin
Bernhard Hiller16-Nov-14 21:36
Bernhard Hiller16-Nov-14 21:36 
QuestionCalling a MySQL Stored Procedure over SSH using .PEM file Pin
bpoker16-Nov-14 4:33
bpoker16-Nov-14 4:33 
AnswerRe: Calling a MySQL Stored Procedure over SSH using .PEM file Pin
Richard MacCutchan16-Nov-14 5:10
mveRichard MacCutchan16-Nov-14 5:10 
Questionissue with date format when exporting to excel Pin
parkway15-Nov-14 6:23
parkway15-Nov-14 6:23 
Hi,
I have a grid where i have to filter the columns like multiple search filter and what ever records i get in the grid i am doing export to excel in c#

Everything was went well except the date column in the grid the date column data is in this format 2014/11//15


here is my c# code which i am using to remove special characters

private void getfilterdata(string filter, out string key, out string val)
{
key = string.Empty;
val = string.Empty;
if (!string.IsNullOrEmpty(filter))
{
string[] retval2 = filter.Split(new string[] { "data" }, StringSplitOptions.RemoveEmptyEntries);
if (retval2 != null && retval2.Count() > 1 && !string.IsNullOrEmpty(retval2[1]))
{
string[] strkeys = retval2[0].Split(new char[] { '"' }, StringSplitOptions.RemoveEmptyEntries);
if (strkeys.Length >= 3 && !string.IsNullOrEmpty(strkeys[3]))
{
key = strkeys[3];
val = RemoveSpecialCharacters(retval2[1]);
}
}
}
}

In the key its shows column name and in the val it shows data..
in the val i am getting data as 20141115.


So its not matching and while exporting its empty i am not getting any records becaus e of this

this is my code for RemoveSpecialCharacters

public static string RemoveSpecialCharacters(string str)
{
return Regex.Replace(str, "[^a-zA-Z0-9_.]+", "", RegexOptions.Compiled);
}



Any help plz.....

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.