Hi , i'm new to c# programming my objective is to type an operation (operands and operators) in a single `expressionTextBox` and if I click on a `resultButton` the result will be displayed.
For example, i have 3 variables of type `float` named `var1`, `var2` and var3 (in a table of data with their content values ) I want to write in the `expressionTextBox ``var2 + var3=` (or `*`or `-`or `sin`or `cos`...) and the result of `var1` will be displayed in `ResultTextbox`.
The textbox has to be able to understand more than one variable from datatable and has to understand operands and functions for the operation. Itried with a code, can someone help me to do that my problem is in the first textbox (`expressionTextbox`) because i know how to update the result in `var1` , are there other methods using `listBox`, for example?
This is a first step below. Am I on the right path?please help !
private void ResultButton_Click(object sender, EventArgs e)
{
con.Open();
string[] parts = expressionTextbox.Text.Split('+');
double intSum = 0;
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "select * from Table_com where Variable=@variable";
cmd.Parameters.Add("@variable", SqlDbType.VarChar).Value = expressionTextbox.Text;
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
intSum = intSum + Convert.ToDouble(dr["Contents"]);
}
ResultTextbox.Text = intSum.ToString();
con.Close();
}