public static NewsInfo Populate(IDataReader reader) { NewsInfo info = new NewsInfo(); for (int i = 0; i < reader.FieldCount; i++) { PropertyInfo property = info.GetType().GetProperty(reader.GetName(i)); Type propType = property.PropertyType; TypeConverters.ITypeConverter typeConverter = TypeConverters.TypeConverterFactory.GetConvertType(propType); property.SetValue(info, Convert.ChangeType(typeConverter.Convert(reader.GetValue(i)), propType), null); } return(info); }
public List<NewsInfo> GetAllNews() { DataTable dt= SqlHelper.ExecuteDataTable("SELECT ID,title,[Date],people FROM dbo.HKSJ_Main", CommandType.Text); List<NewsInfo> list = new List<NewsInfo>(); for (int i = 0; i < dt.Rows.Count; i++) { NewsInfo news = new NewsInfo(); news.ID = (Int32)dt.Rows[i]["ID"]; news.Title = dt.Rows[i]["title"] as string; news.Date = DateTime.Parse(dt.Rows[i]["Date"].ToString()); news.People = dt.Rows[i]["people"] as string; list.Add(news); } return list; }