Datalist绑定

xxx.aspx.cs里的

protected string sql;
    protected void Page_Load(object sender, EventArgs e)
    {
        string sql = "select top 45 id,ComName from job_person where flag=1 order by id";
        bingdatalist(sql, this.DataList1);
    }

    protected void bingdatalist(string p, DataList datalist)
    {
       try
      {
            sql = p;
            datalist.DataSource = DBQuery.OpenQuery(sql);
            datalist.DataBind();
      }
        catch(Exception e)
        {
            //Response.Write(e.Message.ToString());
         }
        finally
        {

        }
    }

 

DBQuery类里的

static SqlConnection conn=DBConnection.getConn();
  static DataTable dt;

  public static DataTable OpenQuery(string sql)
  {
         SqlDataAdapter da=new SqlDataAdapter(sql,conn);
            
         dt=new DataTable();
         try
        {
            da.Fill(dt);
        }
        catch(Exception ex)
       {
              throw ex;
        }
        finally
        {
             da.Dispose();
        }

   return dt;
  }

 

xxx.aspx里的

<li><img src="../hr/images/IconArrowGreen.gif" vspace='2' >&nbsp&nbsp<a href="../hr/Job_View.aspx?UID=<%#Eval("id") %>" class='FGree' target='_blank'>

<%#Eval("ComName") %><img src="image/new.gif" border="0" /></a></li>