TimeOut on SqlDataAdapter. Fill

[Dan]

I've created a web form which fills a DataGrid with a DataSet generated from
the SqlDataAdapter. Fill method. The adapter's query takes about 30 seconds
to complete when I run it in the SQL Server Query Analyzer, but when I run
it from my web page I kept getting a TimeOut exception. So then, as an
experiment, I changed the way I created the adapter to the following:

SqlConnection conn = new SqlConnection(m _Conn);
SqlCommand sqlCommand = new SqlCommand(m_Qu ery, conn);
sqlCommand.Comm andTimeout = 0;
m_Adapter = new SqlDataAdapter( sqlCommand);

However, I'm still getting the TimeOut exception on the adapter.Fill method.
What do I need to do to make this work? The relevant portion of the
exception reads as follows:
System.Data.Sql Client.SqlExcep tion: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. at
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or cmdBehavior,
RunBehavior runBehavior, Boolean returnStream) at
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or behavior) at
System.Data.Sql Client.SqlComma nd.System.Data. IDbCommand.Exec uteReader(Comma n
dBehavior behavior) at
System.Data.Com mon.DbDataAdapt er.FillFromComm and(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) at System.Data.Com mon.DbDataAdapt er.Fill(DataSet
dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand
command, CommandBehavior behavior) at
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, String srcTable)

[Dan]

Never mind. I had an extraneous databound column in my datagrid.
"Dan" <da*@dontspamme .com> wrote in message
news:ej******** ******@TK2MSFTN GP10.phx.gbl...

I've created a web form which fills a DataGrid with a DataSet generated from the SqlDataAdapter. Fill method. The adapter's query takes about 30 seconds to complete when I run it in the SQL Server Query Analyzer, but when I run
it from my web page I kept getting a TimeOut exception. So then, as an
experiment, I changed the way I created the adapter to the following:

SqlConnection conn = new SqlConnection(m _Conn);
SqlCommand sqlCommand = new SqlCommand(m_Qu ery, conn);
sqlCommand.Comm andTimeout = 0;
m_Adapter = new SqlDataAdapter( sqlCommand);

However, I'm still getting the TimeOut exception on the adapter.Fill method. What do I need to do to make this work? The relevant portion of the
exception reads as follows:
System.Data.Sql Client.SqlExcep tion: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. at
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or behavior) at System.Data.Sql Client.SqlComma nd.System.Data. IDbCommand.Exec uteReader(Comma n dBehavior behavior) at
System.Data.Com mon.DbDataAdapt er.FillFromComm and(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) at System.Data.Com mon.DbDataAdapt er.Fill(DataSet
dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand
command, CommandBehavior behavior) at
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, String srcTable)