DataSet，DataTable，List实现将Sql Server表中的数据绑定到GradView中

最新推荐文章于 2021-01-18 18:38:15 发布

liu_111111

最新推荐文章于 2021-01-18 18:38:15 发布

阅读量921

点赞数

分类专栏：程序文章标签： dataset DataSet DataTable datatable list List 数据绑定到GradView

本文链接：https://blog.csdn.net/liu_111111/article/details/8243680

版权

程序专栏收录该内容

121 篇文章 0 订阅

订阅专栏

-------------DataSet,DataTable--------

前台：
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
<br />
<asp:Button ID="Button1" runat="server" οnclick="Button1_Click" Text="Button" />
</div>
</form>
</body>

后台:
protected void Button1_Click(object sender, EventArgs e)
{
string constr = "data source=.;initial catalog=Test1;User id=sa;password=111111";
string sql = "select * from MyStudents";
SqlDataAdapter adpter = new SqlDataAdapter(sql, constr);

#region adpter到数据集dataset中
//DataSet ds = new DataSet();
//adpter.Fill(ds);
//GridView1.DataSource = ds;
//GridView1.DataBind();
#endregion

#region adpter到数据表DataTable中
DataTable dt = new DataTable();
adpter.Fill(0, 10, dt);//显示表中的前十行
GridView1.DataSource = dt;
GridView1.DataBind();
#endregion
}

-------------list-----------
前台：
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
<br />
<asp:Button ID="btnListGridView" runat="server" Text="Button"
οnclick="btnListGridView_Click" />
</div>
</form>
</body>

Student类：
public class Student
{
public int Fid { get; set; }
public string Fname { get; set; }
public int Fage { get; set; }
public bool Fgender { get; set; }
public int Fmath { get; set; }
public int Fenglish { get; set; }
public DateTime Fbirthday { get; set; }
}

后台：
protected void btnListGridView_Click(object sender, EventArgs e)
{
string connStr = "data source=.;initial catalog=Test1;User id=sa;password=111111";

using (SqlConnection conn = new SqlConnection(connStr))
{
string sqlStr = "select * from MyStudents";
using (SqlCommand cmd = new SqlCommand(sqlStr, conn))
{
conn.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
List<Student> list = new List<Student>();

while (reader.Read())
{

// 表中字段： Fid Fname Fage Fgender Fmath Fenglish Fbirthday

Student sInfo = new Student();
sInfo.Fid = reader.GetInt32(reader.GetOrdinal("FId"));
sInfo.Fname = reader.GetString(reader.GetOrdinal("FName"));
sInfo.Fage = reader.GetInt32(reader.GetOrdinal("fAge"));
sInfo.Fgender = reader.GetBoolean(reader.GetOrdinal("FGender"));
sInfo.Fmath = reader.GetInt32(reader.GetOrdinal("FMath"));
sInfo.Fenglish = reader.GetInt32(reader.GetOrdinal("FEnglish"));
sInfo.Fbirthday = reader.GetDateTime(reader.GetOrdinal("FBirthday"));
list.Add(sInfo);
}
}
}
GridView1.DataSource = GetUserInfoAll(connStr, sqlStr);
GridView1.DataBind();
}
}

liu_111111

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
DataSet，DataTable，List实现将Sql Server表中的数据绑定到GradView中

-------------DataSet,DataTable--------前台：后台: protected void Button1_Click(object sender, EventArgs e) {
复制链接

扫一扫

专栏目录