public static SpacePostCategoryInfo[] GetSpacePostCategories(DataTable dt) { if (dt == null || dt.Rows.Count == 0) { return(null); } SpacePostCategoryInfo[] spacepostcategoriesinfoarray = new SpacePostCategoryInfo[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { spacepostcategoriesinfoarray[i].ID = TypeConverter.ObjectToInt(dt.Rows[i]["id"]); spacepostcategoriesinfoarray[i].PostID = TypeConverter.ObjectToInt(dt.Rows[i]["postid"]); spacepostcategoriesinfoarray[i].CategoryID = TypeConverter.ObjectToInt(dt.Rows[i]["categoryid"]); } dt.Dispose(); return(spacepostcategoriesinfoarray); }
public static SpacePostCategoryInfo GetSpacePostCategoryInfo(IDataReader idatareader) { if (idatareader == null) { return(null); } if (idatareader.Read()) { SpacePostCategoryInfo spacepostcategoriesinfo = new SpacePostCategoryInfo(); spacepostcategoriesinfo.ID = TypeConverter.ObjectToInt(idatareader["id"]); spacepostcategoriesinfo.PostID = TypeConverter.ObjectToInt(idatareader["postid"]); spacepostcategoriesinfo.CategoryID = TypeConverter.ObjectToInt(idatareader["categoryid"]); idatareader.Close(); return(spacepostcategoriesinfo); } else { idatareader.Close(); return(null); } }