標籤:connect ring using char run exec oev nic --
Users表
using System;using System.Collections.Generic;using System.Data.SqlClient;using System.Linq;using System.Web;/// <summary>/// Users 的摘要說明/// </summary>public class Users{ public Users() { } public int Ids { get; set; } public string Ucode { get; set; } public string UserName { get; set; } public string password { get; set; } public string NickName { get; set; } public bool Sex { get; set; } public string Sexstr { get { return Sex ? "男" : "女"; } } public DateTime Birthday { get; set; } public string Nation { get; set; } public string NationName { get { string s = "無"; SqlConnection conn = new SqlConnection("server=.;database=Date0504;user=sa;pwd=y920106k"); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "select * from UserNation where [email protected]"; cmd.Parameters.Add("@a",Nation); conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { s = dr["NationName"].ToString(); } conn.Close(); return s; } }
UsersData
using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Data.SqlClient;/// <summary>/// UsersData 的摘要說明/// </summary>public class UsersData{ SqlConnection conn; SqlCommand cmd; public UsersData() { conn = new SqlConnection("server=.;database=Date0504;user=sa;pwd=y920106k"); cmd = conn.CreateCommand(); } public List<Users >SelectAll() { List<Users> ulist = new List<Users>(); cmd.CommandText = "select * from Users"; conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { Users u = new Users(); u.Ids = Convert.ToInt32(dr["Ids"]); u.Ucode = dr["Ucode"].ToString(); u.UserName = dr["UserName"].ToString(); u.password = dr["PassWord"].ToString(); u.NickName = dr["NickName"].ToString(); u.Sex = Convert.ToBoolean(dr["Sex"]); u.Birthday = Convert.ToDateTime(dr["Birthday"]); u.Nation = dr["Nation"].ToString(); ulist.Add(u); } conn.Close(); return ulist; }}
Default
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %><!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> <table> <%--建立一個表格--%> <thead> <%--表格的表頭--%> <tr> <%--每一列的列名--%> <td>Ids</td> <td>編號</td> <td>使用者民</td> <td>密碼</td> <td>暱稱</td> <td>性別</td> <td>生日</td> <td>民族</td> </tr> </thead> <tbody> <%--表格的主體--%> <asp:Repeater ID="Repeater1" runat="server"><%--迴圈資料--%> <ItemTemplate> <tr> <%--括弧內為屬性名稱--%> <td><%#Eval("Ids") %></td> <td><%#Eval("Ucode") %></td> <td><%#Eval("UserName") %></td> <td><%#Eval("Password") %></td> <td><%#Eval("NickName") %></td> <td><%#Eval("Sexstr") %></td><%--屬性擴充的性別--%> <td><%#Eval("Birthday","{0:yyyy年MM月dd日}") %></td><%--中括弧內的0代表前面的資料看找後面的展示--%> <td><%#Eval("NationName") %></td> </tr> </ItemTemplate> </asp:Repeater> </tbody> </table> </div> </form></body></html>
Default右鍵查看代碼
using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;public partial class _Default : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) { Repeater1.DataSource = new UsersData().SelectAll();//指定資料來源 Repeater1.DataBind();//綁定資料來源 }}
WebForm資料繫結