入门Visual studio 2005数据库的经典实例(ASP.NET+SQL 2000)

(1)插入数据库的语言:
create database DB

use DB

create table personLike
(
 ID int primary key,
 Likecontent varchar(100) not null
)

insert into personLike values (1,'游戏')
insert into personLike values (2,'旅游')
insert into personLike values (3,'体育')
insert into personLike values (4,'游戏')
insert into personLike values (5,'体育')
insert into personLike values (6,'游戏')

(2)建立类的连接:-------记得到如命名空间
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

/// <summary>
/// DB 的摘要说明
/// </summary>
public class DB
{
 public DB()
 {
     
  //
  // TODO: 在此处添加构造函数逻辑
  //
 }
      public static SqlConnection createConnection()
        {
            SqlConnection conn = new SqlConnection("server=.;database=DB;Uid=sa;pwd=;");---本机用"."表示
            return conn;
        }

(3)在Default.aspx中拖入CheckBoxList控件(改名为ChkBpersonLike)和一个按钮控件
(4)引入类的方法:DB 为ChkBpersonLike绑定 为按钮编写事件.----Default.aspx.cs中
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;   //记得导入命名空间

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)     ------------如果没有这个就会把每次选中得清空所以按钮永远也不显示选中得项(牢记)
        {
            SqlConnection con = DB.createConnection();
            con.Open();
            SqlCommand cmd = new SqlCommand("select * from personLike",con);
            SqlDataReader sdr = cmd.ExecuteReader();
            this.ChkBpersonLike.DataSource = sdr;
            this.ChkBpersonLike.DataTextField = "Likecontent";
            this.ChkBpersonLike.DataValueField = "ID";
            this.ChkBpersonLike.RepeatColumns = 3; //显示一行有多少个;
            this.ChkBpersonLike.DataBind();
            sdr.Close();
            con.Close();
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        for (int i = 0; i < this.ChkBpersonLike.Items.Count - 1; i++)
        {
            if (this.ChkBpersonLike.Items[i].Selected)
            {
                Response.Write(this.ChkBpersonLike.Items[i].Value + "--"
                    + this.ChkBpersonLike.Items[i].Text+"<br>");
            }
        }
    }
}

按F5,选择不调试,运行成功.