binddata.cs

主要是一个图片展示效果

            lbtnUpPage.Enabled = true;
            lbtnNextPage.Enabled = true;
            lbtnFirstPage.Enabled = true;
            lbtnLastPage.Enabled = true;
            if (pds.IsFirstPage)
            {
                lbtnFirstPage.Enabled = false;
                lbtnUpPage.Enabled = false;
            }
            if (pds.IsLastPage)
            {
                lbtnNextPage.Enabled = false;
                lbtnLastPage.Enabled = false;
            }

            foreach (ListItem item in drdlstPageList.Items)
            {
                if (currentPage.ToString() == item.Text)
                {
                    drdlstPageList.Text = currentPage.ToString();
                }
            }

            dlstList.DataSource = pds;
            dlstList.DataKeyField = ID;
            dlstList.DataBind();
        }
        return count;
    }

    public int Padings(HiddenField hiddenCurrentPage, LinkButton lbtnUpPage, LinkButton lbtnNextPage, LinkButton lbtnFirstPage, LinkButton lbtnLastPage, DropDownList drdlstPageList, DataList dlstList, string ID, int PageSize, Page pages,string wayStatus,string city,string category,int startAcreage,int endAcreage,double startPrice,double endPrice,string doorType,Label lblPageCount)
    {
        int count = 0;
        int currentPage = int.Parse(hiddenCurrentPage.Value);
        PagedDataSource pds = new PagedDataSource();
        DataTable dt = hc.HouseSearchInfo(wayStatus, city, category, startAcreage, endAcreage, startPrice, endPrice, doorType).Tables[0];
        if (dt.Rows.Count > 0)
        {
            pds.DataSource = dt.DefaultView;
            pds.AllowPaging = true;
            pds.PageSize = PageSize;
            pds.CurrentPageIndex = currentPage - 1;
            count = pds.PageCount;
            lblPageCount.Text = "共有" + count.ToString() + "页";
            if (drdlstPageList.Items.Count > 0)
            {
                drdlstPageList.Items.Clear();
            }
            for (int i = 1; i <= pds.PageCount; i++)
            {
                drdlstPageList.Items.Add(i.ToString());
            }

            lbtnUpPage.Enabled = true;
            lbtnNextPage.Enabled = true;
            lbtnFirstPage.Enabled = true;
            lbtnLastPage.Enabled = true;
            if (pds.IsFirstPage)
            {
                lbtnFirstPage.Enabled = false;
                lbtnUpPage.Enabled = false;
            }
            if (pds.IsLastPage)
            {
                lbtnNextPage.Enabled = false;
                lbtnLastPage.Enabled = false;
            }

            foreach (ListItem item in drdlstPageList.Items)
            {
                if (currentPage.ToString() == item.Text)
                {
                    drdlstPageList.Text = currentPage.ToString();
                }
            }

            dlstList.DataSource = pds;
            dlstList.DataKeyField = ID;
            dlstList.DataBind();
        }
        return count;
    }

    #endregion

    #region  DropDownList数据绑定　无参数;带一个参数;读取文本数据绑定;读取文本并填充value属性
    //DropDownList数据绑定
    public void GetDropDownListInfo(DropDownList drdlst, string texts, string values,string procedureName)
    {
        DataSet ds = Real.DAL.SqlHelper.ExecuteDataset(strCon,CommandType.StoredProcedure,procedureName,null);
        drdlst.DataSource = ds;
        drdlst.DataTextField = texts;
        drdlst.DataValueField = values;
        drdlst.DataBind();
    }

    //DropDownList数据绑定
    public void GetDropDownListInfo(DropDownList drdlst, string texts, string values, string procedureName,int para)
    {
        SqlParameter[] paras = { new SqlParameter("@Para",para)};
        DataSet ds = Real.DAL.SqlHelper.ExecuteDataset(strCon, CommandType.StoredProcedure, procedureName, paras);
        drdlst.DataSource = ds;
        drdlst.DataTextField = texts;
        drdlst.DataValueField = values;
        drdlst.DataBind();
    }

    //将存贮在文本文件中的数据绑定到dropdownlist中
    public void GetDropDownListInfo(DropDownList drdlst, string filePath)
    {
        string fileName = HttpContext.Current.Server.MapPath(filePath);
        string content = "";
        StreamReader sr = null;
        try
        {
            //打开文件并显示其内容
            sr = new StreamReader(fileName, System.Text.Encoding.Default);
            for (string line = sr.ReadLine(); line != null; line = sr.ReadLine())
            {
                content += line.ToString();
            }
            string[] arr = content.Split('.');
            for (int i = 0; i < arr.Length; i++)
            {
                drdlst.Items.Add(arr[i].ToString());
            }
        }
        catch (IOException ee)
        {
            HttpContext.Current.Response.Write("<script>alert("+ee.Message+")</script>");
        }
        finally
        {
            if (sr != null)
            {
                sr.Close();
            }
        }
    }

    //将存贮在文本文件中的数据绑定到dropdownlist中
    public void GetDropDownListInfos(DropDownList drdlst, string filePath)
    {
        string fileName = HttpContext.Current.Server.MapPath(filePath);
        string content = "";
        StreamReader sr = null;
        try
        {
            //打开文件并显示其内容
            sr = new StreamReader(fileName, System.Text.Encoding.Default);
            for (string line = sr.ReadLine(); line != null; line = sr.ReadLine())
            {
                content += line.ToString();
            }
            string[] arr = content.Split('|');
            string text = arr[0].ToString();
            string value = arr[1].ToString();
            string[] textArr = text.Split(',');
            string[] valueArr = value.Split(',');
            for (int i = 0; i < textArr.Length; i++)
            {
                ListItem li = new ListItem();
                li.Text = textArr[i].ToString();
                li.Value = valueArr[i].ToString();
                drdlst.Items.Add(li);
            }
        }
        catch (IOException ee)
        {
            HttpContext.Current.Response.Write("<script>alert(" + ee.Message + ")</script>");
        }
        finally
        {
            if (sr != null)
            {
                sr.Close();
            }
        }
    }
    #endregion

    #region 数据读取器
    /// <summary> 
    /// 返回一个数据读取器 
    /// </summary> 
    /// <param name="strSQL">要执行的SQL语句,为字符串类型string</param> 
    /// <returns></returns> 
    public static SqlDataReader ExecuteDataReader(string sql)
    {
        SqlConnection con = new SqlConnection();
        con.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"].ToString();
        SqlCommand cmd = new SqlCommand(sql, con);
        SqlDataReader sdr;

        try
        {
            con.Open();
            sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
        }
        catch (System.Data.SqlClient.SqlException e)
        {
            throw new Exception(e.Message);
        }

        return sdr;
    }
    #endregion
}