Essay/EssayInfo.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

namespace Essay
{
    public partial class EssayInfo : System.Web.UI.Page
    {public string sql = "Data Source=. ;Trusted_Connection=SSPI;Initial Catalog=Essay";
        protected void Page_Load(object sender, EventArgs e)
        {
            object obj = Request.QueryString["Title"];
            if (obj != null)
            {
                string str = "select * from EssayInfo where Title='"+obj+"'";
                Select(str);
            }
            
        }
        public void Select(string str) {
            SqlConnection conn = new SqlConnection(sql);
            conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = str;
            SqlDataReader dr = cmd.ExecuteReader();
            dr.Read();
            this.LTitle.Text = dr["Title"].ToString();
            this.LAbstract.Text = dr["Abstract"].ToString();
        }
    }
    }