public static DataTable GetFeeds(int moduleId) { using (var dataTable = new DataTable()) { dataTable.Columns.Add("ItemID", typeof(int)); dataTable.Columns.Add("ItemGuid", typeof(Guid)); dataTable.Columns.Add("ModuleID", typeof(int)); dataTable.Columns.Add("ModuleGuid", typeof(Guid)); dataTable.Columns.Add("Author", typeof(string)); dataTable.Columns.Add("Url", typeof(string)); dataTable.Columns.Add("RssUrl", typeof(string)); dataTable.Columns.Add("ImageUrl", typeof(string)); dataTable.Columns.Add("FeedType", typeof(string)); dataTable.Columns.Add("PublishByDefault", typeof(bool)); dataTable.Columns.Add("TotalEntries", typeof(int)); using (IDataReader reader = DBRssFeed.GetFeeds(moduleId)) { while (reader.Read()) { DataRow row = dataTable.NewRow(); row["ItemID"] = reader["ItemID"]; row["ItemGuid"] = new Guid(reader["ItemGuid"].ToString()); row["ModuleID"] = reader["ModuleID"]; row["ModuleGuid"] = new Guid(reader["ModuleGuid"].ToString()); row["Author"] = reader["Author"]; row["Url"] = reader["Url"]; row["RssUrl"] = reader["RssUrl"]; row["ImageUrl"] = reader["ImageUrl"]; row["FeedType"] = reader["FeedType"]; row["PublishByDefault"] = Convert.ToBoolean(reader["PublishByDefault"]); row["TotalEntries"] = Convert.ToInt32(reader["TotalEntries"]); dataTable.Rows.Add(row); } }//using return(dataTable); }//using }
public static DataSet GetFeeds(int moduleId) { return(DBRssFeed.GetFeeds(moduleId)); }