Details.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 Details : System.Web.UI.Page
{
    public  string id;
    public string hitnum;
    protected void Page_Load(object sender, EventArgs e)
    {
        id = Request.QueryString["id"];
        if (!IsPostBack)
        {
           
            listbind();
        }   
    }

    ICollection Createsoure()
    {    
        
        string str = "select *  from Movies where MovID='"+id+"'";
        SqlConnection con = DB.getcon();
        DataSet ds = new DataSet();
        SqlDataAdapter sda = new SqlDataAdapter(str, con);
        sda.Fill(ds,"Mov");
        return ds.Tables["Mov"].DefaultView;


    }
    public void listbind()
    {
        this.DataList1.DataSource = Createsoure();
        DataList1.DataBind();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        
    }
    protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
    {
        hitnum = ((Label)e.Item.FindControl("Label8")).Text;
        int num = Convert.ToInt32(hitnum) + 1;
        SqlConnection con = DB.getcon();
        con.Open();
        SqlCommand cmd = new SqlCommand("update Movies set HitNum='" + num + "' where MovID=" + id, con);
        cmd.ExecuteNonQuery();
        con.Close();
        Response.Redirect("play.aspx?ID=" + id);

    }
}