Error while binding data to gridview in asp.net using vb

Question

I am getting following error and I can't resolve it.

<%@ Page Language="VB" MasterPageFile ="~/Master.master"  AutoEventWireup="false" CodeFile="test.aspx.vb" Inherits="test" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
<asp:GridView ID="GridView1"  PageSize ="50" runat="server" AllowPaging="True"    AllowSorting="True"
           AutoGenerateColumns="False" DataKeyNames="ID">
         <Columns>
            <asp:TemplateField HeaderText="ID">
                <ItemTemplate>
                    <%# Container.DataItemIndex + 1 %>
                 </ItemTemplate>
             </asp:TemplateField>
             <asp:BoundField DataField="Dname" HeaderText="Player" SortExpression="Dname" />
             <asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
             <asp:BoundField DataField="GTScore" HeaderText="Score" 
                 SortExpression="GTScore" />
          </Columns>
        </asp:GridView>
</asp:Content>

This is my .aspx code

 Partial Class test
 Inherits System.Web.UI.Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles     Me.Load
    Dim fDate As Date = New Date(Today.Year, Today.Month, 1)
    Dim tDate As Date = New Date(Today.Year, Today.Month, Date.DaysInMonth(Today.Year, Today.Month))
    GridView1.DataSource = Game.SelectToppersOfMonth1(fDate, tDate)
    GridView1.DataBind()
End Sub
End Class

This is my .aspx.vb code.I am just calling stored proc from function SelectToppersOfMonth1

and my select query in stored procedure is

SELECT TOP 100 A.[dispName] as [Dname], A.[city] as [City], SUM(B.[score]) as [GTScore]

FROM [Players] A,[Games] B 

WHERE A.[ID]=B.[playerID] AND B.[startedOn] BETWEEN @fromDate AND @toDate 

GROUP BY A.[dispName], A.[city] ORDER BY [GTScore] DESC

I am getting error

DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ID'.
Description: An unhandled exception occurred during the execution of the current web       request. Please review the stack trace for more information about the error and     where it originated in the code.

Exception Details: System.Web.HttpException: DataBinding: 'System.Data.DataRowView'  does not contain a property with the name 'ID'.

Davide Piras · Accepted Answer · 2011-12-09 11:51:36Z

2

just remove this from the page markup: DataKeyNames="ID" because your query is not returning any ID column and that breaks the binding. Or modify your SQL query to return also the ID column.

answered Dec 9, 2011 at 11:51

Davide Piras

44.7k10 gold badges103 silver badges150 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

chetan p Over a year ago

Thank you very much.. I am newbie in asp.net i dont even know meaning of DataKeyNames i just copy pasted it from other gridview.. :D

lnu · Accepted Answer · 2011-12-09 11:50:28Z

0

You reference ID in the DataKeyNames property and it's not in your sql query. Is it normal?

answered Dec 9, 2011 at 11:50

lnu

1,4141 gold badge9 silver badges25 bronze badges

2 Comments

Davide Piras Over a year ago

he is not binding the ID in/to the header; he is trying to set ID as DataKeyName so the grid is aware of which column is PK in the bound data.

lnu Over a year ago

I was editing my answer then I saw your comment... you've been too fast

Collectives™ on Stack Overflow

Error while binding data to gridview in asp.net using vb

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related