default2.aspx.cs

ASPNET程序开发范例宝典02.rar ASP.NET application development paradigm Baodian 02

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;

public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request["id"] != null)
        {
            SqlConnection con = new SqlConnection("server=(local);user id=sa;pwd=;Database=db_03");
            con.Open();
            SqlDataAdapter ada = new SqlDataAdapter("select * from tb_19 where id=" + Request["id"], con);
            DataSet ds = new DataSet();
            ada.Fill(ds, "tb_files");
            DataRowView rv = ds.Tables["tb_files"].DefaultView[0];
            TextBox1.Text = rv["name"].ToString();
            TextBox2.Text = rv["datatime"].ToString();
            TextBox3.Text = rv["fileload"].ToString();
        }
    }
}