以下是示例代码:
创建数据库表:
CREATE TABLE PersonalizedList ( UserID INT NOT NULL, ItemName VARCHAR(50) NOT NULL )
在ASP.NET页面上显示个性化列表:
在用户登录的代码中查询用户个性化列表信息:
string userID = HttpContext.Current.User.Identity.Name; //获取当前用户ID string connString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString; //获取数据库连接字符串 using (SqlConnection conn = new SqlConnection(connString)) { SqlCommand cmd = new SqlCommand("SELECT ItemName FROM PersonalizedList WHERE UserID=@UserID", conn); cmd.Parameters.AddWithValue("@UserID", userID); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); lvPersonalizedList.DataSource = dt; lvPersonalizedList.DataBind(); }