DataBinding：'System.Data.DataRowView'不包含名为'id'的属性。 [英] DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'id'.

问题描述

这里我将数据绑定到下拉列表，但如果有可能帮我感谢我会收到错误



我的代码是：

Hi,

Here i am binding data to dropdownlist, but i got error if it possible help me thanks

my code is:

string Qry = "select c.category from category c inner join ProductAdd pa on pa.categoryid =c.id where pa.id='"+strEdited+"'";
               dt = adpro.GetData(Qry);
               if (dt.Rows.Count > 0)
               {
                   ddlcategory.DataSource = dt;
                   ddlcategory.DataTextField = "category";
                   ddlcategory.DataBind();
               }

推荐答案

所以用select id改变你的查询

So change your query with select id also

string Qry = "select c.id, c.category from category c inner join ProductAdd pa on pa.categoryid =c.id where pa.id='"+strEdited+"'";
 dt = adpro.GetData(Qry);
               if (dt.Rows.Count > 0)
               {
                   ddlcategory.DataSource = dt;
                   ddlcategory.DataTextField = "category";
ddlcategory.DataTextValue="id";
                   ddlcategory.DataBind();
               }

这篇关于DataBinding：'System.Data.DataRowView'不包含名为'id'的属性。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！