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);
}
