请教DataList 显示图片的问题

[hbpolo]

我有3张表 一个Book表 一个BookImg表 一个BookType表
Book表有2个外键分别与BookImg表和BookType想关联！

接下来是实体类

Book类 

public class Book
    {
        private string _BookId;

        public string BookId
        {
            get { return _BookId; }
            set { _BookId = value; }
        }

        private string _BookName;

        public string BookName
        {
            get { return _BookName; }
            set { _BookName = value; }
        }

        private int _BookTypeID;

        public int BookTypeID
        {
            get { return _BookTypeID; }
            set { _BookTypeID = value; }
        }

        private int _ImgID;

        public int ImgID
        {
            get { return _ImgID; }
            set { _ImgID = value; }
        }

        private decimal _OriginalPrice;

        public decimal OriginalPrice
        {
            get { return _OriginalPrice; }
            set { _OriginalPrice = value; }
        }

        private decimal _SellPrice;

        public decimal SellPrice
        {
            get { return _SellPrice; }
            set { _SellPrice = value; }
        }

        private string _Description;

        public string Description
        {
            get { return _Description; }
            set { _Description = value; }
        }

        private int _Quatity;

        public int Quatity
        {
            get { return _Quatity; }
            set { _Quatity = value; }
        }

        private int _Storage;

        public int Storage
        {
            get { return _Storage; }
            set { _Storage = value; }
        }

        private string _Author;

        public string Author
        {
            get { return _Author; }
            set { _Author = value; }
        }
        private string _Press;

        public string Press
        {
            get { return _Press; }
            set { _Press = value; }
        }
        private string _DatePressed;

        public string DatePressed
        {
            get { return _DatePressed; }
            set { _DatePressed = value; }
        }
        private string _ISBN;

        public string ISBN
        {
            get { return _ISBN; }
            set { _ISBN = value; }
        }
    }

BookType 类
public class BookType
    {
        private int _BookTypeID;

        public int BookTypeID
        {
            get { return _BookTypeID; }
            set { _BookTypeID = value; }
        }

        private string _BookTypeName;

        public string BookTypeName
        {
            get { return _BookTypeName; }
            set { _BookTypeName = value; }
        }

        private int _ParentID;

        public int ParentID
        {
            get { return _ParentID; }
            set { _ParentID = value; }
        }

        private int _OrderBy;

        public int OrderBy
        {
            get { return _OrderBy; }
            set { _OrderBy = value; }
        }
    }

BookImg类

 public class BookImg
    {
        private int _ImgID;

        public int ImgID
        {
            get { return _ImgID; }
            set { _ImgID = value; }
        }

        private string _ImgPath;

        public string ImgPath
        {
            get { return _ImgPath; }
            set { _ImgPath = value; }
        }
    }

我 在 DLL 有个 Book 类 返回 List<Book>

调用存储过程

下面是存储过程的代码：

ALTER procedure [dbo].[sp_SelctAllBook]

as

select book.*, booktype.booktypename,bookimg.imgpath from book
left join bookimg on book.imgid = bookimg.imgid
left join booktype on book.booktypeid = booktype.booktypeid


执行存储过程后的图：





请问要怎么在 DataList 显示 Book表的信息， 主要问题是如何显示 BookTypeName 和 BookImgPath

多谢大家的帮忙

[gengwanshanreally]

这样解决图片问题：

Book类 

public class Book
    {
        private string _BookId;

        public string BookId
        {
            get { return _BookId; }
            set { _BookId = value; }
        }

        private string _BookName;

        public string BookName
        {
            get { return _BookName; }
            set { _BookName = value; }
        }

        private int _bookType;

        public int BookType
        {
            get { return _bookType; }
            set { _bookType = value; }
        }

        private int _bookImg;

        public int BookImg
        {
            get { return _bookImg; }
            set { _bookImg= value; }
        }

        private decimal _OriginalPrice;

        public decimal OriginalPrice
        {
            get { return _OriginalPrice; }
            set { _OriginalPrice = value; }
        }

        private decimal _SellPrice;

        public decimal SellPrice
        {
            get { return _SellPrice; }
            set { _SellPrice = value; }
        }

        private string _Description;

        public string Description
        {
            get { return _Description; }
            set { _Description = value; }
        }

        private int _Quatity;

        public int Quatity
        {
            get { return _Quatity; }
            set { _Quatity = value; }
        }

        private int _Storage;

        public int Storage
        {
            get { return _Storage; }
            set { _Storage = value; }
        }

        private string _Author;

        public string Author
        {
            get { return _Author; }
            set { _Author = value; }
        }
        private string _Press;

        public string Press
        {
            get { return _Press; }
            set { _Press = value; }
        }
        private string _DatePressed;

        public string DatePressed
        {
            get { return _DatePressed; }
            set { _DatePressed = value; }
        }
        private string _ISBN;

        public string ISBN
        {
            get { return _ISBN; }
            set { _ISBN = value; }
        }
    }

[gengwanshanreally]

用BookType去访问BookTypeName
用BookImg去访问BookImgPath

[mingch516548094]

写子查询就好了啊

[hbpolo]

恕我愚钝，麻烦再详细解答下

[hbpolo]

浮

[hbpolo]

顶上去