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

    }
    protected void btuclick(object sender, EventArgs e)
    {
        string str = ((Button)sender).CommandArgument.ToString();
        SqlConnection con = new SqlConnection("data source=localhost;uid=sa;pwd=;database=Ebusiness");
        con.Open();
        SqlCommand comm = new SqlCommand( );
        comm.CommandText = "select title,content,Auth,[date],click from petnews1 where id=" + str;
        comm.Connection = con;
        SqlDataReader reader = comm.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();
       
        //更新访问次数
      
        comm.CommandText = "update petnews1 set click=" + i.ToString() + " where id=" + str;
        comm.ExecuteNonQuery();
        con.Close();
    }

}