private void setup() { using (SqlDataReader dr = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(GlobalSettings.DbDSN, CommandType.Text, "select macroPropertyHidden, macroPropertyType, macroPropertySortOrder, macroPropertyAlias, macroPropertyName from cmsMacroProperty where id = @id", new SqlParameter("@id", _id))) { if (dr.Read()) { _public = bool.Parse(dr["macroPropertyHidden"].ToString()); _sortOrder = int.Parse(dr["macroPropertySortOrder"].ToString()); _alias = dr["macroPropertyAlias"].ToString(); _name = dr["macroPropertyName"].ToString(); _type = new MacroPropertyType(int.Parse(dr["macroPropertyType"].ToString())); } } }
private void setup() { using (SqlDataReader dr = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(GlobalSettings.DbDSN, CommandType.Text, "select macroPropertyHidden, macroPropertyType, macroPropertySortOrder, macroPropertyAlias, macroPropertyName from cmsMacroProperty where id = @id", new SqlParameter("@id", _id))) { if(dr.Read()) { _public = bool.Parse(dr["macroPropertyHidden"].ToString()); _sortOrder = int.Parse(dr["macroPropertySortOrder"].ToString()); _alias = dr["macroPropertyAlias"].ToString(); _name = dr["macroPropertyName"].ToString(); _type = new MacroPropertyType(int.Parse(dr["macroPropertyType"].ToString())); } } }