content.aspx.cs

前台首页：users/index.aspx 后台首页：login.aspx 这是一个有关宠物的电子商务网站 注：后台的“售后服务” 和“数据统计”这两块由于时间原因暂时 没完成。由于技术问

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 content : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Reader(); 
    }

    //上一篇
    protected void Button1_Click(object sender, EventArgs e)
    {
       Session["content"]=Convert.ToInt32( Session["content"].ToString())-1;
       Reader();
    }
    //下一篇
    protected void Button2_Click(object sender, EventArgs e)
    {
        Session["content"] = Convert.ToInt32(Session["content"].ToString())+1;
        Reader();
    }
    void Reader()
    {
        SqlConnection sqlcon = new SqlConnection("data source=localhost;uid=sa;pwd=;database=news");
        SqlCommand objsqlcomm = new SqlCommand();
        sqlcon.Open();
        objsqlcomm.Connection = sqlcon;

        objsqlcomm.CommandText = "select title,content,Auth,[date],click from petnews1 where id=" + Session["content"].ToString();

        SqlDataAdapter Adap = new SqlDataAdapter("select title,content,Auth,[date],click from petnews1 where id=" + Session["content"].ToString(), sqlcon);
        DataSet ds = new DataSet();
        Adap.Fill(ds, "petnews11");
        DataRow dr;
        dr = ds.Tables["petnews11"].Rows[0];

        SqlDataReader reader = objsqlcomm.ExecuteReader();
        reader.Read();


        TextBox1.Text = reader.GetString(0);
        TextBox6.Text = reader.GetString(1);
        TextBox2.Text = reader.GetString(2);
        TextBox5.Text = reader.GetDateTime(3).ToString();
        TextBox3.Text = TextBox2.Text;
        int i = reader.GetInt32(4);
        i++;
        TextBox4.Text = i.ToString(); //访问次数 
        //Session["content"] = null;

        reader.Close();
        //显示上一篇标题
        SqlCommand objsqlcomm1 = new SqlCommand();
        objsqlcomm1.Connection = sqlcon;
        objsqlcomm1.CommandText = "select title from petnews1 where id=" + (Convert.ToInt32(Session["content"].ToString()) -1).ToString();
        SqlDataReader reader1 = objsqlcomm1.ExecuteReader();
        if (reader1.Read())
        {
            TextBox7.Text = reader1.GetString(0);
        }
        else
            TextBox7.Text = "没有了";
        reader1.Close();

        //显示下一篇标题
        SqlCommand objsqlcomm2 = new SqlCommand();
        objsqlcomm2.Connection = sqlcon;
        objsqlcomm2.CommandText = "select title from petnews1 where id=" + (Convert.ToInt32(Session["content"].ToString()) + 1).ToString();
        SqlDataReader reader2 = objsqlcomm2.ExecuteReader();
        if (reader2.Read())
        {

            TextBox8.Text = reader2.GetString(0);
        }
        else
            TextBox8.Text = "没有了";
        reader2.Close();
        //更新访问次数

        objsqlcomm.CommandText = "update petnews1 set click=" + i.ToString() + " where id=" + Session["content"].ToString();
        objsqlcomm.ExecuteNonQuery();
        sqlcon.Close();
    }
}