Dim cmd As New SqlCommand("select bb.GoodCode, aa.PicType, aa.GoodPathPic " & _
"from EMGoodPic aa ," & _
"EMGood bb " & _
"where aa.GoodID = bb.GoodID and bb.GoodCode = @pi", condb)
Using rd = cmd.ExecuteReader()
While rd.Read()
Response.Write(rd("GoodPathPic") & "<br/>")
imgShow.ImageUrl = rd("GoodPathPic")
End While
End Using