本文共 1335 字，大约阅读时间需要 4 分钟。

webform1.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="test9_6.WebForm1" %>
           
   
    
    
        
         
    
    
   

webform1.aspx.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.SqlClient;namespace test9_6{    public partial class WebForm1 : System.Web.UI.Page    {        protected void Page_Load(object sender, EventArgs e)        {            //数据库连接字符串            string connectionString = @"Data Source=LAPTOP-AQKEN65V\SQLEXPRESS08;Initial Catalog=db_CoffeeManagement;User ID=sa;Password=123456;";            SqlConnection myCon = new SqlConnection(connectionString);            myCon.Open();            //查询sql            string selectSql = "select * from tb_shangPin";            SqlDataAdapter adapter = new SqlDataAdapter(selectSql, myCon);            System.Data.DataSet myDs = new System.Data.DataSet();            adapter.Fill(myDs);            //这里只配置了数据源和绑定关系，没有做其他详细的配置            GridView1.DataSource = myDs;            GridView1.DataBind();        }    }}

sql

CREATE DATABASE db_CoffeeManagement;USE db_CoffeeManagement;GO;CREATE TABLE tb_shangPin(sp_id int identity(1,1) not null primary key,sp_name nvarchar(50) not null,sp_price money,sp_type nchar(10));