test12.aspx.cs

互联网程序设计的课程

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;
using DBClass;
public partial class backup_test12 : System.Web.UI.Page
{
    DB db = new DB();
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection conn = db.OpenConn();
        string str="select * from ZhouQinfo ";
    try
    {
        SqlCommand MyCmd = new SqlCommand(str, conn); SqlDataReader r = MyCmd.ExecuteReader();
        //r=GetDataReader(str,conn);
        while (r.Read() == true)
        {
            ListBox1.Items.Add(string.Format("[{0}]{1}", r[0], r[1]));
        }
        r.Close();
    }
    catch (Exception err)
    {
        Response.Write("<script>alert('读取记录失败')</script>");
    }
    finally
    {
        db.DisposeConn(conn);
    }

    }



    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection conn = db.OpenConn();
        string str = "select ZhouQ from ZhouQinfo where ZhouQH=1";
        SqlCommand MyCmd = new SqlCommand(str, conn);  ;
        Label1.Text = MyCmd.ExecuteScalar().ToString(); 
        db.DisposeConn(conn);
    }
}