ASP.Net LINQ数据源错误是ListView

发布于 2024-11-17 11:53:23 字数 1605 浏览 7 评论 0原文

我有一个成功的查询，从 RESTAURANT 数据库的 REST_NAME 列返回 8 个项目。我的数据绑定成功，但当我尝试访问 LivtView 中的项目时，我收到错误：“System.String”不包含名为“REST_NAME”的属性。

数据访问层的LINQ查询：

public IEnumerable<string> getRestaurants(int cuisineID)
{
    var restaurantList = from RESTAURANT in db.RESTAURANTs
                         where RESTAURANT.CUISINE_ID == cuisineID
                         orderby RESTAURANT.REST_NAME ascending
                         select RESTAURANT.REST_NAME;
    return restaurantList;
}

业务逻辑层的函数：

public class BLgetRestaurants
{
    public IEnumerable<string> getRestaurants(int cuisineID)
    {
        DLgetRestaurants obj = new DLgetRestaurants();
        var restaurantList = obj.getRestaurants(cuisineID);
        return restaurantList;
    }
}

业务层函数的前端调用：

BLgetRestaurants obj = new BLgetRestaurants();
var restaurantListing = obj.getRestaurants(cuisineID);
ListRestaurants.DataSource = restaurantListing;
ListRestaurants.DataBind();

*最后，ListView调用得到REST_NAME 数据：**

<ItemTemplate>
    <div id="RestName"><%#Eval("REST_NAME") %></div><br />
     <div id="ListItems">
          <div id="RestCuisine">Cuisine: </div>
          <div id="RestCity">Location: </div>
          <div id="RestAvgRating">Average Rating: </div>
          <div id="RestPrice">Price: </div> 
     </div>  
</ItemTemplate>

感谢您的帮助！〜苏珊〜

原文

I have a successful query that is returning 8 items from REST_NAME columen of the RESTAURANT db. I have a successful databind but when I try to access the item in the LivtView I receive an error: 'System.String' does not contain a property with the name 'REST_NAME'.

LINQ query from Data Access Layer:

public IEnumerable<string> getRestaurants(int cuisineID)
{
    var restaurantList = from RESTAURANT in db.RESTAURANTs
                         where RESTAURANT.CUISINE_ID == cuisineID
                         orderby RESTAURANT.REST_NAME ascending
                         select RESTAURANT.REST_NAME;
    return restaurantList;
}

Function in Business Logic Layer:

public class BLgetRestaurants
{
    public IEnumerable<string> getRestaurants(int cuisineID)
    {
        DLgetRestaurants obj = new DLgetRestaurants();
        var restaurantList = obj.getRestaurants(cuisineID);
        return restaurantList;
    }
}

Front End call of Business Layer function:

BLgetRestaurants obj = new BLgetRestaurants();
var restaurantListing = obj.getRestaurants(cuisineID);
ListRestaurants.DataSource = restaurantListing;
ListRestaurants.DataBind();

*Finally, the ListView call to get the REST_NAME data:**

<ItemTemplate>
    <div id="RestName"><%#Eval("REST_NAME") %></div><br />
     <div id="ListItems">
          <div id="RestCuisine">Cuisine: </div>
          <div id="RestCity">Location: </div>
          <div id="RestAvgRating">Average Rating: </div>
          <div id="RestPrice">Price: </div> 
     </div>  
</ItemTemplate>

Thanks for your help!
~susan~

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

万水千山粽是情ミ 2024-11-24 11:53:23

尝试

 <div id="RestName"><%# Container.DataItem %></div><br />

如果您正在处理具有 REST_NAME 的 IEnumerable，则可以使用 <%#Eval("REST_NAME") %>作为它的领域之一。但由于您使用的是 IEnumerable 您不能这样做。

Try

 <div id="RestName"><%# Container.DataItem %></div><br />

You can use <%#Eval("REST_NAME") %> if you are dealing with IEnumerable<Restaurant> which has REST_NAME as one of it's fields. But since you are using IEnumerable<string> you cannot do that.

回复收藏 0 原文

~没有更多了~