WEB

最新推荐文章于 2024-09-17 19:35:50 发布

原创最新推荐文章于 2024-09-17 19:35:50 发布 · 165 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍如何使用ASP.NET和C#从SQL Server数据库中读取数据，并将其绑定到Web页面上的ListBox和BulletedList控件。通过示例代码展示了如何创建数据库连接、执行SQL查询以及使用数据读取器填充控件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

8.1.3
<%@ Page Language=“C#” AutoEventWireup=“true” CodeFile=“Default.aspx.cs” Inherits="_Default" %>

<form id="form1" runat="server">
    <asp:ListBox ID="ListBox1" runat="server"></asp:ListBox>
    <asp:BulletedList ID="BulletedList1" runat="server">
    </asp:BulletedList>
</form>

然后 using System; using System.Collections.Generic; using System.Data.SqlClient; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{
string connstr = “data source = (localdb)\MSSQLLOCALDB; initial catalog = zln02; integrated security = True”;

protected void Page_Load(object sender, EventArgs e)
{
    using (SqlConnection conn=new SqlConnection(connstr)) {
        SqlCommand cmd = conn.CreateCommand();
        cmd.CommandText = " select Id , name from  [Table] ";
        conn.Open();
        SqlDataReader reader = cmd.ExecuteReader();
        ListBox1.DataSource = reader;
        ListBox1.DataTextField = "Id";
        ListBox1.DataValueField = "name";
        ListBox1.DataBind();
    }
    bindproduct();
}

private void bindproduct()
{
    string ca = ListBox1.SelectedValue;

using(SqlConnection conn=new SqlConnection(connstr))
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = “Select name from [Table]”;
cmd.Parameters.AddWithValue("@ca", ca);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
BulletedList1.DataSource = reader;
BulletedList1.DataTextField = “name”;
BulletedList1.DataBind();
}
}
}