IList转数据集，一个最简单的应用。

来源：互联网发布：淘宝刷单平台网站编辑：程序博客网时间：2024/06/05 21:18

这是我做的一个最简单的一个应用，供自已学习吧！代码如下：

数据访问层的一个方法

public static IList GetIListToOrder(string sql) { connection = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString); connection.Open(); SqlDataAdapter da = new SqlDataAdapter(sql, connection); DataTable dt = new DataTable(); da.Fill(dt); IList list = new ArrayList(); for (int i = 0; i < dt.Rows.Count; i++) { Order neworder = new Order(); neworder.O_id = dt.Rows[i]["o_id"].ToString(); neworder.O_buyerid = dt.Rows[i]["o_buyerid"].ToString(); list.Add(neworder); } return list; }页面后台代码：

using System;using System.Collections;using System.Data;using System.Reflection;namespace WebApplication1{ public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { DataTable dt = GetOrder(); if (dt.Rows.Count > 0) { TextBox1.Text = dt.Rows[1]["o_id"].ToString(); TextBox2.Text = dt.Rows[1]["o_buyerid"].ToString(); } } /// <summary> /// 将集合类转换成DataTable /// </summary> /// <param name="list">集合</param> /// <returns></returns> public static DataTable ToDataTable(IList list) { DataTable result = new DataTable(); if (list.Count > 0) { PropertyInfo[] propertys = list[0].GetType().GetProperties(); foreach (PropertyInfo pi in propertys) { result.Columns.Add(pi.Name, pi.PropertyType); } for (int i = 0; i < list.Count; i++) { ArrayList tempList = new ArrayList(); foreach (PropertyInfo pi in propertys) { object obj = pi.GetValue(list[i], null); tempList.Add(obj); } object[] array = tempList.ToArray(); result.LoadDataRow(array, true); } } return result; } /// <summary> /// 查询 /// </summary> /// <returns>返回DataTable对象</returns> DataTable GetOrder() { IList list = new ArrayList(); list = DBHelper.GetIListToOrder("select * from [Order]"); DataTable dt = ToDataTable(list); return dt; } }}

页面前台代码：

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="WebApplication1.WebForm1" %><html xmlns="http://www.w3.org/1999/xhtml" ><head runat="server"> <title>无标题页</title></head><body> <form id="form1" runat="server"> <div> <asp:Label ID="Label1" runat="server" Text="o_id"></asp:Label> <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox> <br /> <br /> <asp:Label ID="Label2" runat="server" Text="o_buyerid"></asp:Label> <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox> </div> </form></body></html>

效果图如下：