detail.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;
public partial class detail : System.Web.UI.Page
{

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            this.DataBindToDataList();
        }
    }



    protected void Button1_Click(object sender, EventArgs e)
    {
        string name1, content1, time1,newsid1; 
        newsid1 = Convert.ToString(Request.QueryString["newsid"]);
        name1 = txtname.Text.Trim();
        content1 = txtCon.Text.Trim();
        time1 = DateTime.Now.ToString();
        SqlConnection con = DB.CreateCon();
        con.Open();
        SqlCommand cmd = new SqlCommand("insert into guest(username,content,postTime,newsid) values ('" + name1 + "','" + content1 + "','" + time1 + "','"+newsid1+"')", con);
        cmd.ExecuteReader();
        this.DataBindToDataList();
    }

    private void DataBindToDataList()
    {
        string newsid1;
        newsid1 = Convert.ToString(Request.QueryString["newsid"]);
        SqlConnection con = DB.CreateCon();
        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = new SqlCommand("select * from guest where newsid='"+newsid1+"'", con);
        DataSet ds = new DataSet();
        sda.Fill(ds, "gue");
        this.DataList2.DataSource = ds.Tables["gue"];
        this.DataList2.DataBind();
    }

    
}