Select语句列给出了gridview的异常 [英] Select statement columns gives exception with gridview

问题描述

我从表中选择一些列并用gridview绑定它。我得到一个例外，说明'在所选数据源上找不到名为'OrderQty'的字段或属性。''line'getUserInfo.DataBind（）;'。当我在SQL查询中直接使用它时，select语句表现良好。

我的代码：

I select some columns from a table and bound it with a gridview. I get an exception stating that 'A field or property with the name 'OrderQty' was not found on the selected data source.' at line 'getUserInfo.DataBind();'. The select statement performs well when I use it direct in SQL query.
My Code:

protected void BindGridview()
   {
       {
           con.Open();
           SqlCommand cmd = new SqlCommand("SELECT c.Categoryname,p.ProductName,SUM(t.OrderQty)as 'Total required' FROM txfile t join Category c on c.CategoryId=t.CategoryId join Product p on p.ProductId= t.ProductId WHERE t.DateToDespatch='2014/01/15' GROUP BY c.CategoryName,p.ProductName,t.Blank", con);
           SqlDataReader dr = cmd.ExecuteReader();
           gvUserInfo.DataSource = dr;
           gvUserInfo.DataBind();
           con.Close();
       }
   }

<asp:GridView ID="gvUserInfo" runat="server"  AutoGenerateColumns="false" >
<HeaderStyle BackColor="#df5015" Font-Bold="true" ForeColor="White"/>
  <Columns >
              <asp:BoundField DataField="CategoryName" HeaderText="Category"  />
               <asp:BoundField DataField="ProductName" HeaderText="Product"  />
               <asp:BoundField DataField="OrderQty" HeaderText="Total qty required"  />
                <asp:BoundField DataField="" HeaderText="Units"  />
            </Columns>
</asp:GridView>

推荐答案

您好朋友



您的查询是





你必须改变SUM （t.OrderQty）为'总需要'

所需总数文本为OrderQty

我修改了查询请使用它





SELECT c.Categoryname，p.ProductName，SUM（t.OrderQty）as'OrderQty'FROM txfile t

加入c类c .CategoryId = t.CategoryId加入产品p on p.ProductId = t.ProductId WHERE t.DateToDespatch ='2014/01 / 15'

GROUP BY c.CategoryName，p.ProductName，t.Blank





谢谢

Hello Friend

your query is


you have to change "SUM(t.OrderQty)as 'Total required'"
"Total required" text as OrderQty
I modified the query please use it


SELECT c.Categoryname,p.ProductName,SUM(t.OrderQty)as 'OrderQty' FROM txfile t
join Category c on c.CategoryId=t.CategoryId join Product p on p.ProductId= t.ProductId WHERE t.DateToDespatch='2014/01/15'
GROUP BY c.CategoryName,p.ProductName,t.Blank


Thanks

正如第一个解决方案所示，你应该使用给出的别名Datafield绑定列中的sql select查询。另请注意，别名不应包含空格。

As the First solution suggests , you should use the alias name given in the sql select query in Datafield bind column. Also , note that alias should not contain spaces .

这篇关于Select语句列给出了gridview的异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！