void cbx1_SelectionChanged(object sender, EventArgs e)
{
XmlDocument xmldoc = new XmlDocument();
XmlNodeList xmlnode;
int i = 0;
FileStream fs = new FileStream(xmlfilePath, FileMode.Open, FileAccess.Read);
xmldoc.Load(fs);
xmlnode = xmldoc.GetElementsByTagName(this.cbx1.SelectedItem.ToString());
isDataBaseRelated = (dbfunction.IndexOf(this.cbx1.SelectedItem.ToString()) > -1);
if (xmlnode.Count == 1)
{
xmlnode[i].ChildNodes.Item(0).InnerText.Trim();
this.desc.Text = xmlnode[0].ChildNodes.Item(0).InnerText.Trim();
this.sytx.Text = xmlnode[i].ChildNodes.Item(1).InnerText.Trim();
this.t1.Text = xmlnode[i].ChildNodes.Item(2).InnerText.Trim();
this.res.Text = engine.ParseAndComputeFormula(this.t1.Text);
}
else
{
this.desc.Text = "Not available";
this.sytx.Text = "Not available";
this.res.Text = "";
}
}
private void CalculateEngine()
{
//Call this to reset static members in case other form is loaded first:
Syncfusion.Calculate.CalcEngine.ResetSheetFamilyID();
//Create a CalcEngine object, tie it to the gridDataBoundGrid that implements ICalcData:
engine = new Syncfusion.Calculate.CalcEngine(gridControl1);
engine.ParseAndComputeFormula("=A1");
this.formulaNameCollection = GetFunctionNames();
this.functionCountLable.Text = "CALCULATE SUPPORTS " + formulaNameCollection.Count.ToString() + " FORMULAS.";
this.formulaCombo.DataSource = formulaNameCollection;
this.formulaCombo.SelectedIndex = 0;
}
void formulaCombo_SelectedIndexChanged(object sender, EventArgs e)
{
XmlDocument xmldoc = new XmlDocument();
XmlNodeList xmlnode;
int i = 0;
string xmlText = File.ReadAllText(xmlfilePath);
xmldoc.Load(xmlfilePath);
xmlnode = xmldoc.GetElementsByTagName(this.formulaCombo.Text.ToString());
if (dbfunction.IndexOf(this.formulaCombo.Text) > -1)
{
this.gridControl1.PopulateHeaders(GridRangeInfo.Cells(0, 1, gridControl1.RowCount, gridControl1.ColCount), dbDT);
this.gridControl1.PopulateValues(GridRangeInfo.Cells(1, 1, gridControl1.RowCount, gridControl1.ColCount), dbDT);
}
else
{
this.gridControl1.PopulateHeaders(GridRangeInfo.Cells(0, 1, gridControl1.RowCount, gridControl1.ColCount), dt);
this.gridControl1.PopulateValues(GridRangeInfo.Cells(1, 1, gridControl1.RowCount, gridControl1.ColCount), dt);
}
try
{
if (xmlnode.Count == 1)
{
xmlnode[i].ChildNodes.Item(0).InnerText.Trim();
this.descrLable.Text = xmlnode[0].ChildNodes.Item(0).InnerText.Trim();
this.syntaxLable.Text = xmlnode[i].ChildNodes.Item(1).InnerText.Trim();
this.textBox1.Text = xmlnode[i].ChildNodes.Item(2).InnerText.Trim();
this.resultLable.Text = engine.ParseAndComputeFormula(this.textBox1.Text);
}
else
{
this.textBox1.Text = "";
this.descrLable.Text = "Not available";
this.syntaxLable.Text = "Not available";
this.resultLable.Text = "";
}
}
catch (Exception ex)
{
this.resultLable.Text = ex.Message;
}
}
