private void CurrSubmit_Click(object sender, EventArgs e) { try { int id = int.Parse(CurrID.Text); string sqlString = "SELECT * FROM CURRENCYTABLE WHERE ID =" + id; using (DigiDapter dg = new DigiDapter(sqlString)) { if (!dg.HasRows) { } dg.Add("CURRENCY", CurrName.Text); dg.Add("CURRENCYSYMBOL", CurrSymbol.Text); dg.Add("CHANGETOEURO", StaticFunctions.FixDecimal(CurrChange1.Text)); dg.Add("CHANGEFROMEURO", StaticFunctions.FixDecimal(CurrChange2.Text)); dg.Execute("CURRENCYTABLE", "ID=" + id); } CurrencyRepeater.DataSource = DatabaseConnection.CreateDataset("SELECT * FROM CURRENCYTABLE").Tables[0]; CurrencyRepeater.DataBind(); CancelForm(); Start(); } catch { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + Root.rm.GetString("Curtxt12") + "');</script>"); } }
private void Start() { CurrSubmit.Text = Root.rm.GetString("Save"); NewCurrSubmit.Text = Root.rm.GetString("Save"); CurrChange1.Attributes.Add("onchange", "change(0)"); CurrChange2.Attributes.Add("onchange", "change(1)"); CancelForm(); CurrencyRepeater.DataSource = DatabaseConnection.CreateDataset("SELECT * FROM CURRENCYTABLE").Tables[0]; CurrencyRepeater.DataBind(); CurrencyRepeater.Visible = true; currencyTable.Visible = true; currencySymbol.Text = DatabaseConnection.SqlScalar("SELECT CURRENCY FROM CURRENCYTABLE WHERE (CHANGETOEURO=1 AND CHANGEFROMEURO=1)"); ChangeCurrency.Text = Root.rm.GetString("Curtxt7"); companyCurrencyTable.Visible = false; }