Busqueda avanzada

[Peterpay]

en vez de executeReader
usa

BeginExecuteReader

DataTable table = new DataTable(); // Declarado a nivel de la clase.

SqlConnection connection =new SqlConnection(connectionstring + "async=true;");
SqlCommand command = new SqlCommand("MyStoredProcedure", connection);
command.CommandType = CommandType.StoredProcedure;
connection.Open();
command.BeginExecuteReader(Asynchronous, command
,CommandBehavior.CloseConnection); // El comand behavior depende de tus necesidades


private void Asynchronous(IAsyncResult asyncResult)

{

SqlCommand command =
asyncResult.AsyncState as SqlCommand;
SqlDataReader reader;
reader = command.EndExecuteReader(asyncResult);
table.Load(reader);
reader.Close();
}



saludos
peter