Stupid problem with ASP.NET GridView + DataSource + SQLDataReader

Question

I've been through oh so many tutorials and I just can't get this right. I'm trying to populate a gridview based on the results of a stored procedure. I'm probably code blind by now but I really tried to make sure I didn't mess up on something small.

This is the stored procedure:

ALTER PROCEDURE dbo.GetAllPlayersFromGame

(
@gameID int
)AS
/* SELECT all the players within a game */

SELECT playerName FROM Player WHERE gameID = @gameID

This is the code I use to create a datatable which I then use as the datasource for the gridview:

        public static DataTable PopulateGridView(string resultSetQuery)
    {
        //Populate gridview
        OpenConnection();
        SqlCommand sqlCommand = new SqlCommand(resultSetQuery, _sqlConnection);

        SqlDataReader reader = sqlCommand.ExecuteReader();

        DataTable dataTable = new DataTable();
        dataTable.Load(reader);
        return dataTable;
    }

And this is the method that calls everything and is supposed to populate the gridview:

protected void ShowPlayersInGame()
{

    GridViewShowPlayersInGame.DataSource = CreateDatabaseConnection.PopulateGridView("EXEC GetAllPlayersFromGame " + _gameId);
    GridViewShowPlayersInGame.DataBind();
}

When I debug I see all the data in the reader object so the stored procedure works. But something happens when it gets to ShowPlayersInGame because the gridview won't take the data. I've probably missed something rudimentary since I haven't used gridviews a lot before.

Any ideas?

Is the GridView in a custom control with your own CreateChildControls method? — Patrick
– Patrick, Commented Feb 25, 2010 at 10:36
Ehm.. if that's something that can happen when I generate a page from a master page then maybe. I don't know what that really means so I'm not sure. How can I clarify this? — Phil
– Phil, Commented Feb 25, 2010 at 13:35
The answer to that question is a no. The grid view is in a contentplaceholder in a contentpage derived from a master page. It is also in an updatepanel (Ajax). No custom control. — Phil
– Phil, Commented Feb 25, 2010 at 14:20

Phil · Accepted Answer · 2010-02-25 14:50:30Z

1

So.. STUPID problem it was.

  <asp:GridView ID="GridViewShowPlayersInGame" runat="server" 
    AutoGenerateColumns="True" >
</asp:GridView>

I had AutoGenerateColumns="False"

Now it works as intended. Thanks for reading this though!

answered Feb 25, 2010 at 14:50

Phil

3,99212 gold badges42 silver badges63 bronze badges

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

Collectives™ on Stack Overflow

Stupid problem with ASP.NET GridView + DataSource + SQLDataReader

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related