网上购物系统（Task003）——公共数据集Model

最新推荐文章于 2024-08-30 18:24:22 发布

最新推荐文章于 2024-08-30 18:24:22 发布 · 357 阅读

文章标签：

#数据库 #ui

本文介绍如何在ASP.NET应用程序中配置连接字符串，并通过示例演示如何从数据库读取数据并绑定到下拉列表。

源代码：13033480群共享

一、把连接字符串放到Web.config文件中

二、添加类库Model，设置类库项目的程序集名称和默认命名空间。

三、Model中添加类CategoryInfo.cs，代码如下：

using System; using System.Collections.Generic; using System.Text; namespace WestGarden.Model { public class CategoryInfo { private string categoryid; private string name; private string descn; public CategoryInfo() { } public CategoryInfo(string categoryid, string name, string descn) { this.categoryid = categoryid; this.name = name; this.descn = descn; } public string CategoryId { get { return categoryid; } } public string Name { get { return name; } } public string Descn { get { return descn; } } } }

四、Web中添加引用→项目→Model，Defualt,aspx.cs中添加using WestGarden.Model;代码如下：

using System; using System.Data; using System.Data.SqlClient; using System.Configuration; using System.Collections.Generic; using WestGarden.Model; namespace WestGarden.Web { public partial class Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { IList<CategoryInfo> catogories = new List<CategoryInfo>(); string connectionString = ConfigurationManager.ConnectionStrings["NetShopConnString"].ConnectionString; string cmdText = "SELECT * FROM Category"; SqlConnection conn = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.CommandText = cmdText; conn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { CategoryInfo category=new CategoryInfo(rdr.GetString(0), rdr.GetString(1), rdr.GetString(2)); catogories.Add(category); } rdr.Close(); conn.Close(); ddlCategories.DataSource = catogories; ddlCategories.DataTextField = "Name"; ddlCategories.DataValueField = "CategoryId"; ddlCategories.DataBind(); } } }