c# 读取数据库图片路径问题

Question

前台<img src="../upfiles/ <%=fnRec%>"/>
CSpublic partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        fnRec();
    }
    public void fnRec()
    {
        SqlConnection sqlcon = new SqlConnection("Data Source=007-324a07be4d8;User ID=sa;PWD=8812780;DataBase=db_ps");
        string sqltopadcom = "select top 3* from tb_ps";
        SqlCommand myda = new SqlCommand(sqltopadcom, sqlcon);
        sqlcon.Open();
        SqlDataReader dr;
        sqlcon.Close();
    }
}
就是想从数据库读取图片路径,我是新手,希望各位高手帮下忙.数据库图片路径字段为ps_img.谢谢各位

Answer 1

   public byte[] getImage(string strSqlString)
        {
            SqlCommand sqlCmd = new SqlCommand(strSqlString, sqlConn);
            byte[] imageData = null;
            try
            {
                if (sqlConn.State == ConnectionState.Closed)
                {
                    sqlConn.Open();
                }
                SqlDataReader sqlReader = sqlCmd.ExecuteReader();
                while (sqlReader.Read())
                {
                    imageData = (byte[])sqlReader.GetValue(0);
                }
                return imageData;
            }
            catch (SqlException) { }
            finally
            {
                sqlConn.Close();
            }
            return null;
        }

Answer 2

<img src="../upfiles/<%=fnRec()%>"/> 
   public string fnRec()
    {
        SqlConnection sqlcon = new SqlConnection("Data Source=007-324a07be4d8;User ID=sa;PWD=8812780;DataBase=db_ps");
        string sqltopadcom = "select top 3* from tb_ps";
        SqlCommand myda = new SqlCommand(sqltopadcom, sqlcon);
        sqlcon.Open();
        SqlDataReader dr = myda.ExecuteReader();        string _Url = dr["字段"].ToString();
        sqlcon.Close();
        return _Url;
    } 这样看看.

Answer 3

1楼的有点搞不董 2楼的调试后在语句string _Url = dr["ps_img"].ToString();出现"在没有任何数据时进行无效的读取尝试。"

Answer 4

    if (dr.Read())
            {
                string _Url = dr["ps_img"].ToString();
            }

Answer 5

public string fnRec() 
    { 
        SqlConnection sqlcon = new SqlConnection("Data Source=007-324a07be4d8;User ID=sa;PWD=8812780;DataBase=db_ps"); 
        string sqltopadcom = "select top 3* from tb_ps"; 
        string _Url ="";
        SqlCommand myda = new SqlCommand(sqltopadcom, sqlcon); 
        sqlcon.Open(); 
        SqlDataReader dr = myda.ExecuteReader(); 
        dr.open();
         while (dr.Read())
                {
                  _Url=dr["ps_img"].ToString();
                }
        dr.Close();
        sqlcon.Close(); 
        return _Url; 
    } 看看这个。

Answer 6

终于行了  谢谢各位 但图片是打叉的  路径为http://localhost:2589/Upfiles/%20/UpFiles/42.jpg