private void SetVarValue(string VarName, string VarValue) { try { RCData d = new RCData(CI); d.ExecuteStoredProc("exec dbo.rl_SetVariable @VarName, @VarValue", new StProcParam[] { new StProcParam("@VarName", DbType.String, VarName), new StProcParam("@VarValue", DbType.String, VarValue) } ); } catch { } }
private string GetVarValue(string VarName) { string result = ""; try { RCData d = new RCData(CI); DataSet ds = d.GetStProcDataSet("SELECT VarValue, VarName FROM Variables WHERE VarName = @VarName ", new StProcParam[] { new StProcParam("@VarName", DbType.String, VarName) }); if ((ds.Tables.Count > 0) & (ds.Tables[0].Rows.Count > 0)) { try { result = Convert.ToString(ds.Tables[0].Rows[0]["VarValue"]); } catch { result = ""; } } } catch { } return(result); }