Click here to Skip to main content
15,884,176 members
Home / Discussions / C#
   

C#

 
QuestionI want to make 2 Process Synchronization in C# with Mutex Pin
Bharat Bodage24-Nov-21 20:17
Bharat Bodage24-Nov-21 20:17 
AnswerRe: I want to make 2 Process Synchronization in C# with Mutex Pin
OriginalGriff24-Nov-21 21:04
mveOriginalGriff24-Nov-21 21:04 
AnswerRe: I want to make 2 Process Synchronization in C# with Mutex Pin
Richard Deeming24-Nov-21 21:31
mveRichard Deeming24-Nov-21 21:31 
QuestionSource of Integral Calculation Program Using Random Numbers Generation (Kaufman) Pin
Anvar Vaezi23-Nov-21 1:40
Anvar Vaezi23-Nov-21 1:40 
AnswerRe: Source of Integral Calculation Program Using Random Numbers Generation (Kaufman) Pin
OriginalGriff23-Nov-21 3:21
mveOriginalGriff23-Nov-21 3:21 
QuestionFinding Lost Handle Pin
michaelbarb22-Nov-21 8:33
michaelbarb22-Nov-21 8:33 
AnswerRe: Finding Lost Handle Pin
Gerry Schmitz22-Nov-21 9:17
mveGerry Schmitz22-Nov-21 9:17 
QuestionC# How to use place holder in string variable Pin
Mou_kol18-Nov-21 5:34
Mou_kol18-Nov-21 5:34 
see the code how i am creating place holder now. _Yoy has a formula used in excel.
C#
private string _Yoy = @"IF(AND(ISNUMBER(C#),P#>0,NOT(ISERROR(C#/P#))),C#/P#-1,"""")";
             public  string YoY
             {
                 get { return _Yoy; }
                 set { _Yoy = value; }
             }
        
             private void button1_Click(object sender, EventArgs e)
             {
                string strBMFormula = YoY.Replace("P#", "2005.13").Replace("C#", "7777.10");
             }



I am replacing P# & C# with some value at runtime and program working as expected but i am doing this in large loop where Replace() function is getting called repeatedly which may increase memory use.

C#
@"IF(AND(ISNUMBER(C#),P#>0,NOT(ISERROR(C#/P#))),C#/P#-1,"""")";

here i gave 4 double quote because there would two double quote in excel function.

i am using .Net version 4.5

so please suggest me how to create a place holder in string variable and put my value there without using Replace function.

i try this approach too but still no luck.
C#
private void button1_Click(object sender, EventArgs e)
 {
     string strBMFormula = Replacement("A10", "Z210");
 }
    
 private string Replacement(string value1, string value2)
 {
     return @"IF(AND(ISNUMBER({value1}),{value2}>0,NOT(ISERROR({value1}/{value2}))),{value1}/{value2}-1,"""")";
 }

AnswerRe: C# How to use place holder in string variable Pin
Mou_kol18-Nov-21 5:53
Mou_kol18-Nov-21 5:53 
AnswerRe: C# How to use place holder in string variable Pin
phil.o18-Nov-21 12:33
professionalphil.o18-Nov-21 12:33 
GeneralRe: C# How to use place holder in string variable Pin
Mou_kol19-Nov-21 4:03
Mou_kol19-Nov-21 4:03 
AnswerRe: C# How to use place holder in string variable Pin
BillWoodruff19-Nov-21 17:00
professionalBillWoodruff19-Nov-21 17:00 
GeneralRe: C# How to use place holder in string variable Pin
Mou_kol16-Dec-21 6:31
Mou_kol16-Dec-21 6:31 
GeneralRe: C# How to use place holder in string variable Pin
Mou_kol16-Dec-21 6:32
Mou_kol16-Dec-21 6:32 
QuestionAsp.net web api(GET) to pull the records(8 lac records) Pin
Sai Kumar18-Nov-21 4:43
Sai Kumar18-Nov-21 4:43 
AnswerRe: Asp.net web api(GET) to pull the records(8 lac records) Pin
Richard Deeming18-Nov-21 4:47
mveRichard Deeming18-Nov-21 4:47 
GeneralRe: Asp.net web api(GET) to pull the records(8 lac records) Pin
Sai Kumar18-Nov-21 5:06
Sai Kumar18-Nov-21 5:06 
GeneralRe: Asp.net web api(GET) to pull the records(8 lac records) Pin
Richard Deeming18-Nov-21 5:24
mveRichard Deeming18-Nov-21 5:24 
GeneralRe: Asp.net web api(GET) to pull the records(8 lac records) Pin
Sai Kumar18-Nov-21 5:38
Sai Kumar18-Nov-21 5:38 
QuestionTrouble using Canon's EDSDK in VS on mac Pin
Member 1543145718-Nov-21 4:19
Member 1543145718-Nov-21 4:19 
AnswerRe: Trouble using Canon's EDSDK in VS on mac Pin
Luc Pattyn18-Nov-21 4:55
sitebuilderLuc Pattyn18-Nov-21 4:55 
QuestionC sharp Picturebox linking error Pin
ÖmürTokman8-Nov-21 23:05
ÖmürTokman8-Nov-21 23:05 
AnswerRe: C sharp Picturebox linking error Pin
OriginalGriff8-Nov-21 23:27
mveOriginalGriff8-Nov-21 23:27 
GeneralRe: C sharp Picturebox linking error Pin
ÖmürTokman9-Nov-21 0:09
ÖmürTokman9-Nov-21 0:09 
GeneralRe: C sharp Picturebox linking error Pin
OriginalGriff9-Nov-21 0:17
mveOriginalGriff9-Nov-21 0:17 

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.