daohang2.ascx.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 daohang2 : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {
   //    BindRepeater("select top 5* from product where classid=2 order by adddate desc", Repeater1, cn);
        SqlDataReader dr = Class1.sqrea("select * from 手机类型表");
      Repeater1.DataSource = dr;
      Repeater1.DataBind();
      dr.Close();
      dr.Dispose();
    }

    public static void BindRepeater(string sql, Repeater rpt, SqlConnection con)
    {
        SqlDataReader  dr = getDataReader(sql, con);
        rpt.DataSource = dr;
        rpt.DataBind();
        dr.Close();
        dr.Dispose();


    }
     public static SqlDataReader  getDataReader(string strSQL, SqlConnection  cn)
    {
        SqlDataReader  dr = null;
        try
        {

            SqlCommand  comm = new SqlCommand (strSQL, cn);
            dr = comm.ExecuteReader();
            return dr;
        }
        catch (Exception ex)
        {
            if (dr != null && !dr.IsClosed)
                dr.Close();
            cn.Close();
            throw new Exception(ex.Message);
        }

    }

}