前台代码
</tr>
<% if (list != null)
{
foreach (var item in list)
{
%>
<tr>
<td><%= item.Id %></td>
<td><%= item.Login %></td>
</tr>
<%}
} %>
</ul>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using MySql.Data.MySqlClient;
using Present.BLL;
using Presents.Model;
namespace Present.UI.Admin.User
{
public partial class userOper : System.Web.UI.Page
{
public List<UserModel> list = new List<UserModel>();
protected void Page_Load(object sender, EventArgs e)
{
//获取User表
BindUserList();
}
private void BindUserList()
{
MySqlDataReader dr = UserBLL.GetUserList();
while (dr.Read())
{
UserModel usermodel = new UserModel();
usermodel.Id = dr.GetInt32(0);
usermodel.Login = dr.GetString(1);
list.Add(usermodel);
}
}
Model类
using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace Presents.Model { public class UserModel { public int Id { get; set; } public string Login { get; set; } } }