datareader读数据存列表中

最新推荐文章于 2019-02-27 22:49:44 发布

M_arlboro

最新推荐文章于 2019-02-27 22:49:44 发布

阅读量441

点赞数

分类专栏：技术文章标签： asp string server class object cmd

本文链接：https://blog.csdn.net/M_arlboro/article/details/3735405

版权

技术专栏收录该内容

37 篇文章 0 订阅

订阅专栏

gridview要自己绑定列
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
    <Columns>
    <asp:TemplateField HeaderText="学号">
    <ItemTemplate >
    <%# ((visitor)Container.DataItem).Vid %>
    </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="姓名">
    <ItemTemplate>
    <%# ((visitor)Container.DataItem).Vname %>
    </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="地址">
    <ItemTemplate>
    <%# ((visitor)Container.DataItem).Vadd %>
    </ItemTemplate>
    </asp:TemplateField>
    </Columns>
    </asp:GridView>

后台代码
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Collections;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            this.GridView1.DataSource = bind();
            this.GridView1.DataBind();
        }
    }

    public List<visitor> bind()
    {
        List<visitor> lt = new List<visitor>();

        SqlConnection cn = new SqlConnection("server=.;database=pubs;uid=sa;pwd=sa");
        cn.Open();
        SqlCommand cmd = new SqlCommand("select stuid,stuname,stuadd from sj",cn);
        SqlDataReader dr = cmd.ExecuteReader();
        while (dr.Read())
        {   visitor vs = new visitor();
           vs.Vid= dr[0].ToString();
           vs.Vname = dr[1].ToString();
           vs.Vadd = dr[2].ToString();
           lt.Add(vs);
        }

        dr.Close();
        return lt;

    }
}
public class visitor
{
   public string Vname;
   public string Vid;
   public string Vadd;
}