DataGrid does not display?

[Mervin Williams]

I placed a datagrid on my webform, set the datasource to a datareader, and
bound the reader to the datagrid. However, my datagrid does not display.
Here is my code from the Page_Load method:

=============== =============== ======
dgAgmtList = new DataGrid();
SqlConnection con;
string sql;
SqlCommand cmd;
SqlDataReader reader;

sql = "SELECT * FROM [User] WHERE user_id='" + Page.User.Ident ity.Name +
"'";
con = new
SqlConnection(C onfigurationSet tings.AppSettin gs["OFS.Connection String"]);
cmd = new SqlCommand(sql, con);
con.Open();
reader = cmd.ExecuteRead er(CommandBehav ior.CloseConnec tion);

int rowcount = 0;
if (reader.HasRows )
{
while(reader.Re ad())
{ rowcount++; }
}

if (rowcount == 0)
{
reader.Close();
Server.Transfer ("nextpage.aspx ");
}
else
{
dgAgmtList.Data Source = reader;
dgAgmtList.Data Bind();
reader.Close();
}

[William Ryan eMVP]

Set the datagrid.dataso urce =
cmd.ExecuteRead er(CommandBehav ior.CloseConnec tion);
"Mervin Williams" <mw*******@inno vasolutions.net > wrote in message
news:uT******** ******@tk2msftn gp13.phx.gbl...

I placed a datagrid on my webform, set the datasource to a datareader, and
bound the reader to the datagrid. However, my datagrid does not display.
Here is my code from the Page_Load method:

=============== =============== ======
dgAgmtList = new DataGrid();
SqlConnection con;
string sql;
SqlCommand cmd;
SqlDataReader reader;

sql = "SELECT * FROM [User] WHERE user_id='" + Page.User.Ident ity.Name +
"'";
con = new
SqlConnection(C onfigurationSet tings.AppSettin gs["OFS.Connection String"]);
cmd = new SqlCommand(sql, con);
con.Open();
reader = cmd.ExecuteRead er(CommandBehav ior.CloseConnec tion);

int rowcount = 0;
if (reader.HasRows )
{
while(reader.Re ad())
{ rowcount++; }
}

if (rowcount == 0)
{
reader.Close();
Server.Transfer ("nextpage.aspx ");
}
else
{
dgAgmtList.Data Source = reader;
dgAgmtList.Data Bind();
reader.Close();
}