public string getGlobalizedSettings(string appProperty)
{
string sql = "Select appProperty, propertyValue, defaultPropertyValue From ConfigSettings Where appProperty = '" + appProperty + "'";
DataSet ds = database.getDataSet(sql, "tableName");
string propertyValue = ds.Tables["tableName"].Rows[0]["propertyValue"].ToString();
string defaultPropertyValue = ds.Tables["tableName"].Rows[0]["defaultPropertyValue"].ToString();
if (propertyValue != null)
{
return propertyValue;
}
else
{
return defaultPropertyValue;
}
}