源码网商城,靠谱的源码在线交易网站 我的订单 购物车 帮助

源码网商城

C#读取数据库返回泛型集合详解(DataSetToList)

  • 时间:2021-12-17 22:09 编辑: 来源: 阅读:
  • 扫一扫,手机访问
摘要:C#读取数据库返回泛型集合详解(DataSetToList)
[u]复制代码[/u] 代码如下:
protected void Page_Load(object sender, EventArgs e)         {             if (!IsPostBack)             {                 IList<LYZX.Model.LYZX_NewsTypeModel> list = GetList<LYZX.Model.LYZX_NewsTypeModel>(System.Configuration.ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString,                "select * from LYZX_NewsType");                 GridView1.DataSource = list;                 GridView1.DataBind();             }         }         public string GetNewsTypeLink(ref string baseUrl,Guid newsType)         {             return "";         }         /// <summary>                 /// 获取泛型集合                 /// /// </summary>                 /// /// <typeparam name="T">类型</typeparam>                 /// /// <param name="connStr">数据库连接字符串</param>                 /// <param name="sqlStr">要查询的T-SQL</param>                 /// <returns></returns>                 public IList<T> GetList<T>(string connStr, string sqlStr)                {                         using (SqlConnection conn = new SqlConnection(connStr))                        {                                using (SqlDataAdapter sda = new SqlDataAdapter(sqlStr, conn))                                {                                      DataSet ds = new DataSet();                                         sda.Fill(ds);                                        return DataSetToList<T>(ds, 0);                                }                        }               }         /// <summary>                 /// DataSetToList                 /// </summary>                  /// <typeparam name="T">转换类型</typeparam>                 /// <param name="dataSet">数据源</param>                 /// <param name="tableIndex">需要转换表的索引</param>                /// /// <returns>泛型集合</returns>         public IList<T> DataSetToList<T>(DataSet dataset,int tableIndex)         {             //确认参数有效             if (dataset==null || dataset.Tables.Count<=0|| tableIndex<0)             {                 return null;             }             DataTable dt = dataset.Tables[tableIndex];             IList<T> list = new List<T>();             for (int i = 0; i < dt.Rows.Count; i++)             {                 //创建泛型对象                 T _t=Activator.CreateInstance<T>();                 //获取对象所有属性                 PropertyInfo [] propertyInfo=_t.GetType().GetProperties();                 //属性和名称相同时则赋值                 for (int j = 0; j < dt.Columns.Count; j++)                 {                     foreach (PropertyInfo info in propertyInfo)                     {                         if (dt.Columns[j].ColumnName.ToUpper().Equals(info.Name.ToUpper()))                         {                             if (dt.Rows[i][j]!=DBNull.Value)                             {                                 info.SetValue(_t, dt.Rows[i][j], null);                             }                             else                             {                                 info.SetValue(_t, null, null);                             }                             break;                         }                     }                 }                 list.Add(_t);             }             return list;         }
  • 全部评论(0)
联系客服
客服电话:
400-000-3129
微信版

扫一扫进微信版
返回顶部