asp.net 学习笔记从sql中取数据并且绑定到 gridView

最新推荐文章于 2018-02-27 17:21:00 发布

weixin_34240520

最新推荐文章于 2018-02-27 17:21:00 发布

阅读量258

点赞数

文章标签：数据库 c# ui

原文链接：https://my.oschina.net/u/1441493/blog/193756

版权

2019独角兽企业重金招聘Python工程师标准>>>

aspx文件：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="gridviewsort.aspx.cs" Inherits="gridviewsort" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="cityGridView" runat="server" AllowPaging="true" AllowSorting="true" AutoGenerateColumns="false" OnPageIndexChanging="cityGridView_PageIndexChanging" OnSelectedIndexChanged="cityGridView_SelectedIndexChanged" >
            <Columns>
                <asp:BoundField DataField="cityID" HeaderText="城市ID" SortExpression="cityID" />
                <asp:BoundField DataField="cityName" HeaderText="城市名" SortExpression="cityName" />
                <asp:BoundField DataField="proID" HeaderText="父ID" SortExpression="proID" />
            </Columns>
        </asp:GridView>
    </div>
    </form>
</body>
</html>

cs文件

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;


public partial class gridviewsort : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        ViewState["cityName"] = "cityName";
        ViewState["cityID"] = "cityID";
        gridViewBind();
    }
    protected void cityGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {

    }
    protected void cityGridView_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
    protected void gridViewBind()
    {
        /*
         * 建立数据库连接
         * 首先在头部引入DATA包
         * using System.Data;
         * using System.Data.SqlClient;
         */
        SqlConnection dataBaseCon = new SqlConnection("server=ZHOU-COMPUTER;database=Test;UId=mike;password=a03060910");
        //配置sql语句
        string sqlStr = "select * from [dbo].[City]";
        //实例化SqlDataAdapter sql数据适配器对象
        SqlDataAdapter da = new SqlDataAdapter(sqlStr, dataBaseCon);
        //实例化 DataSet 数据集 这个数据集会绑定在gridview上
        DataSet data = new DataSet();
        //向数据集中fill（填入）数据 da填入data
        da.Fill(data,"table");
        //将填好数据的数据集data 绑定到gridView空间上
        this.cityGridView.DataSource = data;
        this.cityGridView.DataBind();

    }
}

转载于:https://my.oschina.net/u/1441493/blog/193756