C# code for Percentage in Goal Seek

Question

0.00/5 (No votes)

See more:

I need to develop an application
where Goal seek function need to be implemented for percentage calculation.

Like

A1     b1   c1   d1
2000   4    80  2080

when I change the d1 cell value
A1 cell value should get changed in excel using goal seek.

Same concept need to be implemented in C#

textbox1  textbox2  textbox3   textBox4   
 2000      4         80          2080

If I change textbox4 then textbox1 and textbox3 would get change

Is it possible?

If yes then please help

Posted 12-Jan-13 4:11am

Sourav Sarkar-SS2

Add a Solution

3 solutions

Solution 1

Yes - just handle the TextChanged event for the textbox, and set the value of the other one.

C#

textbox1.Text = (int.Parse(textbox4.Text) - int.Parse(textbox3.Text)).ToString();

Clearly, you will want to put checking in there to make sure the boxes are numeric, and so forth.

Posted 12-Jan-13 4:31am

OriginalGriff

Comments

[no name] 12-Jan-13 11:17am

you didn't got my question
textbox1 textbox2 textbox3 textBox4
2000 4 80 2080
If I change textbox4 to 3000, then it will be automatically
2884.615385 4 115.3846154 3000

OriginalGriff 12-Jan-13 11:23am

Then you need to specify your goal seeking conditions...am I supposed to read your mind? :laugh:

Solution 2

Can be done easily with TextChanged event and autopostback in text box

XML

<form runat="server">
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
  <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
  <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
  <asp:TextBox ID="TextBox4" runat="server" ontextchanged="TextBox4_TextChanged"
      style="height: 22px" AutoPostBack=true></asp:TextBox>
  </form>

and the cs coding

C#

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        TextBox3.Text = "0";


    }



    protected void TextBox4_TextChanged(object sender, EventArgs e)
    {
     TextBox1.Text = (int.Parse(TextBox4.Text)- int.Parse(TextBox3.Text)).ToString();
    }
}

Posted 12-Jan-13 5:32am

sarathsprakash

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sourav Sarkar-SS2 · Accepted Answer · 2013-01-12T05:43:00

this is the code

C#

double a, b, c,v,d;
           bool x = double.TryParse(textBox2.Text, out a);
           b = (a / 100) + 1;
           x = double.TryParse(textBox1.Text, out v);
           c = v / b;
           d = c * a / 100;
           c = Math.Round(c, 2);
           d = Math.Round(d, 2);
           textBox3.Text = c.ToString();
           textBox4.Text = d.ToString();