using System;
using System.Data;
using System.Configuration;
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 _Default : System.Web.UI.Page
{
    
    SqlOperate sqloperate = new SqlOperate();
    SqlConnection sqlconn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string sqlstr = "select * from goods";
            this.dlDataBind(sqlstr, "goods", "ID", 6);
            string strType = "select distinct TypeName from goods";
            /*SqlDataAdapter MyAdapter = new SqlDataAdapter(sqlstr, sqlconn);
            DataSet ds = new DataSet();
            MyAdapter.Fill(ds, table);
            ps.DataSource = ds.Tables[table].DefaultView;
             */
            SqlDataAdapter MyAdapter = new SqlDataAdapter(strType, sqlconn);
            DataSet ds = new DataSet();
            MyAdapter.Fill(ds, "goods");
            ddlInfoType.DataSource = ds.Tables["goods"].DefaultView;
            //指定DropDownList使用的表里的那些字段 
            ddlInfoType.DataTextField = "TypeName"; //dropdownlist的Text的字段 
            ddlInfoType.DataValueField = "TypeName";//dropdownlist的Value的字段 
            ddlInfoType.DataBind();
            ddlInfoType.Items.Insert(0, new ListItem("", ""));
           // sqloperate.ddlDataBind(ddlInfoType, strType, "TypeName");
        } Session["ID"] = "ID";
    }
    protected void btnSearch_Click(object sender, EventArgs e)
    {
        this.dlInfoBind();
        this.txtSKWord.Text = "";            
    }
    protected void lnkbtnOne_Click(object sender, EventArgs e)
    {
        this.labPage.Text = "1";
        this.dlInfoBind();
    }
    protected void lnkbtnUp_Click(object sender, EventArgs e)
    {
        this.labPage.Text = Convert.ToString(Convert.ToInt32(this.labPage.Text) - 1);
        this.dlInfoBind();
    }
    protected void lnkbtnNext_Click(object sender, EventArgs e)
    {
        this.labPage.Text = Convert.ToString(Convert.ToInt32(this.labPage.Text) + 1);
        this.dlInfoBind();
    }
    protected void lnkbtnBack_Click(object sender, EventArgs e)
    {
        this.labPage.Text = this.labBackPage.Text;
        this.dlInfoBind();
    }
    public void dlDataBind(string sqlstr, string table, string dkf, int psize)
    {
        int curpage = Convert.ToInt32(this.labPage.Text);
        PagedDataSource ps = new PagedDataSource();
        sqlconn.Open();
        SqlDataAdapter MyAdapter = new SqlDataAdapter(sqlstr, sqlconn);
         DataSet ds = new DataSet();
        MyAdapter.Fill(ds, table);
        ps.DataSource = ds.Tables[table].DefaultView;
        ps.AllowPaging = true; //是否可以分页
        ps.PageSize = psize; //显示的数量
        ps.CurrentPageIndex = curpage - 1; //取得当前页的页码
        this.lnkbtnUp.Enabled = true;
        this.lnkbtnNext.Enabled = true;
        this.lnkbtnBack.Enabled = true;
        this.lnkbtnOne.Enabled = true;
        if (curpage == 1)
        {
            this.lnkbtnOne.Enabled = false;//不显示第一页按钮
            this.lnkbtnUp.Enabled = false;//不显示上一页按钮
        }
        if (curpage == ps.PageCount)
        {
            this.lnkbtnNext.Enabled = false;//不显示下一页
            this.lnkbtnBack.Enabled = false;//不显示最后一页
        }
        this.labBackPage.Text = Convert.ToString(ps.PageCount);
        this.dlInfo.DataSource = ps;
        this.dlInfo.DataKeyField = dkf;
        this.dlInfo.DataBind();
      
        sqlconn.Close();
    } 
    public void dlInfoBind()
    {        string sqlstr;
        if (ddlInfoType.SelectedValue == "")
        {
             sqlstr = "select * from goods where Name LIke'%" + txtSKWord.Text.Trim() + "%'";
           
        }
        else {
             sqlstr = "select * from goods where Name  like'%" + txtSKWord.Text.Trim() + "%' and TypeName='" + ddlInfoType.SelectedItem.Text + "'";
        }
        // string sqlstr = "select * from goods where Name  like'%" + txtSKWord.Text.Trim() + "%' and TypeName='" + ddlInfoType.SelectedItem.Text + "'";//and TypeName  = " + ddlInfoType.SelectedValue.Trim() + "";
        if (!sqloperate.comBind(sqlstr))
        {
            Response.Write("<script>alert('没有您要查询的结果,请重新输入')</script>");
            Panel1.Visible = true;
        }
        else
        {
            this.dlDataBind(sqlstr, "goods", "ID", 6);
            /* if (ddlCount.SelectedValue == "1")
             {
                 this.dlDataBind(sqlstr, "goods", "ID", 1);
             }
             if (ddlCount.SelectedValue == "2")
             {
                 this.dlDataBind(sqlstr, "goods", "ID", 2);
             }
             if (ddlCount.SelectedValue == "3")
             {
                 this.dlDataBind(sqlstr, "goods", "ID", 3);
             }
             if (ddlCount.SelectedValue == "4")
             {
                 this.dlDataBind(sqlstr, "goods", "ID", 4);
             }
             if (ddlCount.SelectedValue == "5")
             {
                 this.dlDataBind(sqlstr, "goods", "ID", 5);
             }
             if (ddlCount.SelectedValue == "6")
             {
                 this.dlDataBind(sqlstr, "goods", "ID", 6);
             }
             if (ddlCount.SelectedValue == "7")
             {
                 this.dlDataBind(sqlstr, "goods", "ID", 7);
             }
             if (ddlCount.SelectedValue == "8")
             {
                 this.dlDataBind(sqlstr, "goods", "ID", 8);
             }
             if (ddlCount.SelectedValue == "9")
             {
                 this.dlDataBind(sqlstr, "goods", "ID", 9);
             }
             if (ddlCount.SelectedValue == "10")
             {
                 this.dlDataBind(sqlstr, "goods", "ID", 10);
             }*/
        }
    }      private void dlDataBind(string sqlstr, string p, string p_3)
    {
        throw new Exception("The method or operation is not implemented.");
    }
 
    public void dlInfoBind1()
        
    {   
        string sqlstr = "select * from goods where TypeName='" + ddlInfoType.SelectedItem.Text + "'";//and TypeName  = " + ddlInfoType.SelectedValue.Trim() + "";
        if (!sqloperate.comBind(sqlstr))
        {
            Response.Write("<script>alert('没有您要查询的结果,请重新输入')</script>");
            Panel1.Visible = true;
        }
        else
        {
            this.dlDataBind(sqlstr, "goods", "ID", 6);
        }     
    }    protected void ddlInfoType_SelectedIndexChanged(object sender, EventArgs e)
    {
        this.dlInfoBind1();
    }    protected void LinkButton1_Click(object sender, EventArgs e)
    {       
       
      Response.Redirect("exactly.aspx");
       
     
     
       
    }
  
}

解决方案 »

  1.   

    session["自己定义的name"]=你要存的值
      

  2.   

    我要存的值是一个变量,其实就是从datalist中获取的ID,我是在datalist中添加了一个linkbutton,当点击的时候,就获取该记录的ID号,通过session["ID"]进行获取,就是不知道这个怎么给session["ID"]赋值。麻烦你们帮忙看下啊
      

  3.   

    哎,还是让我自己搞定了,添加了一个itemcommand事件,然后调用了linkbutton事件中的commandargument,和commandname,然后就轻松搞定了哎,你说 的太简单了,你的那个估计很多人多会啊